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 am looking to sort a drilled column chart. On the first hierarchy I want to sort the categories by the count of wells drilled by a certain operator. Then once drilling down to the operator I want to see the count of wells by that operator in a chronological order. However, once I drill down they are still being sorted by the count. Is there a way I can seperate the two and give them unique sorting criteria?
Thank you in advance!
Consider making this 2 different visuals. One count of wells by operator (like you already have) and the 2nd visual is total well drilled by Month. With nobody selected, it will show all wells drilled for everyone. When you select the operator bar from the graph, make sure the 'Filter' Interaction is set instead of 'Highlight' and it will zoom to only the operator selected. See more info here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-visual-interactions/
Proud to give back to the community!
Thank You!
No, it's not supported. When you specify a sorting criteria in a chart, it will be kept for all drill down levels.
Regards,
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |