simple waterfall : problem sorting category

[Anonymous]

Hello community

I am using this visual and I can't sort my categories, I have already tried an order table with column sorting but without result (see picture)

i am looking for same thing like this : 

INDICE 1(pilar)
OLD
ITM
CONCU
QTE
NEW
INDICE 2 (pilar)

I see thaht only in the default waterfall you can sort via this order table

can you help me please ?

Any solution please?

Thanks

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

Add a sorting column that has numbers for sorting which one is before the other, and then sort the main column with this sorting column.

check this link for instructions https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-desktop

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Anonymous]

@Idrissshatila  hi i have another question PLZ 

I have another question please in the waterfall they asked me to make the axis of labels with measurements next to it (percentages)

and also in the categories axis can we add a custom column (label + measure)

[Anonymous]

@Idrissshatila  thank you done !