year-month in a visualization

[KarineDol]

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

[v-xiaotang]

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

result:

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]

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