Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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

     

     

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

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's avatar
Anonymous
Not applicable
9 years ago

Thank you! XD

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      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.