Drill down is combining quarters and months - How to keep the years ?

[bklyn3]

Hello,

I have a bar graph showing sales for per year/quarters/months. 

When I drill down from years to quarters. The graphs combines all the quarters togerther. 

That is the graph shows only 4 bars (1 per quarter)

So Instead 

Q1 2019, Q2019,Q3 2019 Q4 2019,  Q1 2020 , Q2 2020 etc

I get 

Q1 - Q2 - Q3 - Q4 

where Q1  contains all the data for Q1 2019 and 2020  etc..

This is not what I wanted - How can I avoid the quarters to merge ?

Thank you

Regards,

Patrick

[nvprasad]

Hi bklyn3,

Ideally, you should get a result which you expect. If not, can you create a Quarter & Year column in your date table and use that in the axis.

Ex: Q1-2019 ( concatenate of Quarter & Year)

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[VahidDM · Accepted solution]

@bklyn3 

Click on  rather than .

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!