Forum Discussion
Creating Different Sort Order based on what level is Drilled Down On
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 t...
Hi Natalie,
Please see in this screenshot. You can use the visual shown here for your purpose.
Use Line and Bar Visual & drag the fields as shown in the screenshot
You can sort by volume
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.