Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
KarineDol
Frequent Visitor

year-month in a visualization

Hi, i am trying to build a graph with year-month in the x but as i have a jerarchy i have to choose year or month. I want to see both because i have information of different years, for example, from 2020 june to 2021 june....How can i do? I want to see it by month.

I dont want the drill down.

Thanks

 

 

 

 

 

 

 

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi  @KarineDol 

the general solution is to create a calendar table, then build relationship between your dimension table and fact table.

https://community.powerbi.com/t5/Desktop/Calendar-Table/m-p/1860460

vxiaotang_1-1628586945352.png

result:

vxiaotang_0-1628586932067.png

 

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

mahoneypat
Employee
Employee

You need to create a YearMonth column in your Date table with something like FORMAT('Date'[Date], "yyyy mmm").  FYI that this article has DAX you can copy to get a table with that.  It also has special hidden characters so that they show in the correct order in your visual (w/o a Sort By column).  Note you may have to replace the minus signs in the code as it didn't render correctly on the web site.

No Sort Date Tables! – Hoosier BI

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.