Forum Discussion
Sort Axis on Waterfall Chart
Comment that I still have the problem of not being able to sort my waterfall chart in Power BI.
I have tried a measure (that combines CATEGORY and BREAKDOWN), which allows me to sort but I lose the waterfall chart structure, I am left with a normal waterfall with values that vary from start to finish, without being able to customize the first bar (first and last bar must be blue)
If I keep putting together my Category Bars and Breakdown Bars structure, I can't sort the breakdown bars, to leave them fixed and they are automatically sorted by value (when I need them to be sorted by name).
If I create a clustered column chart (to simulate a waterfall) I can give the order of the bars and use the colors as I want, but the size of the bars is too small and I can't customize them.
There is some way to manage to order a waterfall chart with these (fixed) variables:
Mg 2025P
Mg Serv
Mg Eq
C. Op VP
C. Eating
Mg Real
PS: I can't use additional add-ons, any help that helps me with my problem, I'll be very grateful.