Forum Discussion

louisquinet's avatar
louisquinet
Icon for Helper II rankHelper II
2 years ago
Solved

Change 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  
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Chang

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 Chang

 

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

louisquinet's avatar
louisquinet
Icon for Helper II rankHelper II
2 years ago

Thanks