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.
Hi,
I am using Calendar to select timeframe and a bar chart to show the trend.
I have data from January 2016-Present. When I select everything in the timeline i.e. from Jan'16 to Apr'17 and click on "Go to next level in hierarchy", it takes me down from Year-Level to Quarter-Level.
The issue is, it automatically adds all data of Jan'16, Feb'16, Mar'16 with Jan'17, Feb'17, Mar'17 to Q1. It should show the Quarterly data by year not combine it all at once.
How can I fix this issue? I have not been able to find a solution. I understand that the "Expand All down" gives the desired result, but to a new user this will be confusing and may hider the company because of how it's represented if the user isn't aware.
Thanks for your help.
Solved! Go to Solution.
You may drag Date column to Legend field, and select Date Hierarchy. You can also turn on Drill Down.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/
You may drag Date column to Legend field, and select Date Hierarchy. You can also turn on Drill Down.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |