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!
Get a sneak peek into this year's Power Platform Conference Keynote.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!