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 a bar chart which shows the cases due in the next 7 days sorted by date.
It has a drill down which then shows who those cases are allocated to
I want to sort this level by volume whereas it's sorted by name alpha at the moment.
How can I acheieve this? I have data sorted by the volume measure in the table view like a similar post suggests
but it's made no difference.
Thanks for any help
Natalie
Solved! Go to Solution.
Hi Natalie,
Please see in this screenshot. You can use the visual shown here for your purpose.
Go to Ellipses section (...), Select the sort order by volume and you are done.
I don't have the option to do that...
When I click on elipses it only has Export or Remove
Natalie
Hi Natalie,
Please see in this screenshot. You can use the visual shown here for your purpose.
Thank you! XD
Hi,
Trying to sort the second level also resorting the first level.
is there a method to use diffrent Sort for each level
Level 1 : Sort By Date
Level 2: Sort by value
I wanted something similar and found the solution was to sort the column value in the dataset. Pick the column, select modelling on the ribbon, then sort by , then select how you want to sort values.
Then back to the graph....the graph is sort by date and when I drilled into value, it showed the sort order for how I'd sorted the column at dataset level.
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |