Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Sorting x axis in waterfall chart

Hello,

 

I want to sort the x axis based on my requirement, however it sorts the chart automaticall in ascending/descending order, I tried to sort by columns but it did not work...

 

actual chart:

 

result needed:

 

 

Any help would be appreciated!

 

Thanks,

Ekta

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi  Anonymous
    You can add a sort column with a conditional column / connecting dictionary table, 
    Modify sort by this column from data view, 
    Then sort the graph by your category.
    For example:

     

     

    I attached a pbix with the example.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

     

    Anonymous

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi  Anonymous
    You can add a sort column with a conditional column / connecting dictionary table, 
    Modify sort by this column from data view, 
    Then sort the graph by your category.
    For example:

     

     

    I attached a pbix with the example.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

     

    Anonymous