Forum Discussion
louisquinet
Helper II
Helper IIChange order bars stacked column chart
Hello In my Power BI I have a stacked column chart with 4 bars: Tier 1, Tier 2, Tier 3 and Tier 4. What do I have to do to get them in the right order? Thank you in advance Louis
Hi louisquinet ,
It looks like it's sorting by the number after tier, you can get the number by splitting it with power query first and then set it up with sort by column:
One can notice a change in the sorting from my first post.
= Table.AddColumn(#"Changed Type", "Text After Delimiter", each Text.AfterDelimiter([Tier], " "), type text)Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi louisquinet ,
You just need to turn on this option to sort:
It is located in the layout option in column(sort by value)
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.