Sorting x axis in waterfall chart

[Anonymous]

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

[Ritaf1983 · Accepted solution]

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