Forum Discussion
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
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
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.
