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

sornavoor's avatar
sornavoor
Resolver I
10 years ago

AFAIK no direct way.   

 

You could try & see if you can enhance the visual it to add a sorter attribute to the column stacks.  

 

Finally, check the ideas section to see if there is already a request and vote for it; else  add an idea; Will certainly be useful for the masses.  

 

Regards!