Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |