I'm trying to show data sorted by quarter per year with several years in the graph.
When I display the quarters, it is however sorted by quarters with the different years all separated by the quarters.
When I move the year over the quarter, I can not see the quarters anymore - How do I fix this??
I'm working with a calendar table.
Thanks so much!!!
unfortunately, that didn't work but I found a workaround 🙂
Hi @Debooo1 ,
You need to ensure that 'Concatenate Labels' is switched off:
Then expand your chart to the next level using the drill down button:
You can then turn off the visibility of the header icons so end users can't change the drill level:
Proud to be a Datanaut!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.