Order and hierachy of dates

[Debooo1]

Hi,

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!!!

[Debooo1]

unfortunately, that didn't work but I found a workaround 🙂

[BA_Pete]

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:

Pete