Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |