Sum Totals of different categories by date

[Anonymous]

I have created a visual that represents a number for 3 seperate categories by month. What I want next is to be able to drill up and it sum all 3 categories together by month, so Juney 2019 would 94. Currently it drills up to a sum by year.

[dax]

Hi ashleyclements,

I think your sample might be similar to below

This is hard to achieve in the same chart, so one workaround is that you could try to create another chart like below

Then when you click on specify month in first chart, it will show total value of current month

Best Regards,

Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Not quite what I am looking for.

Currently, my graph shows 3 locations and their respective numbers per month. What I want on the next drill up is the 3 locations added together for a grand total per month.