Creating Different Sort Order based on what level is Drilled Down On

[Anonymous]

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

[Anonymous]

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

[BhaveshPatel]

Go to Ellipses section (...), Select the sort order by volume and you are done.

[Anonymous]

I don't have the option to do that...

When I click on elipses it only has Export or Remove

Natalie

[BhaveshPatel · Accepted solution]

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

[Anonymous]

Thank you! XD

[Anonymous]

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 

[Anonymous]

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.