Forum Discussion

ggenzi's avatar
ggenzi
Advocate I
10 years ago
Solved

Sorting stacks in a Stacked Bar Chart

BI novice here, I've been playing with the software for about a month and I am beginning to use it seriously. I have read posts about how to sort the different columns in a stacked bar chart, but I d...
Need Help
  • ggenzi's avatar
    ggenzi
    10 years ago

    Ok so thanks to your help I've figured it out. I simply created a new table with two columns:

    Column one: original category name (numerical value)

    Column two: tweaked category names with increasingly more spaces (classified as categorical)

     

    I then established a relationship between the new table and and the old one with the data, and in the "Legend" field of the chart I dragged the new field (Column two).

     

    And it worked! Definitely more complex than needed though

     

    Thanks

ggenzi's avatar
ggenzi
Advocate I
10 years ago

Very interesting, thanks. I am not sure how to connect the original tiers to the new spaced description but I'll try, thanks!

ggenzi's avatar
ggenzi
Advocate I
10 years ago

Ok so thanks to your help I've figured it out. I simply created a new table with two columns:

Column one: original category name (numerical value)

Column two: tweaked category names with increasingly more spaces (classified as categorical)

 

I then established a relationship between the new table and and the old one with the data, and in the "Legend" field of the chart I dragged the new field (Column two).

 

And it worked! Definitely more complex than needed though

 

Thanks