Forum Discussion

markmess77's avatar
markmess77
Resolver I
2 years ago
Solved

Stacked bar chart not sorting axis properly with parameters

I have a stacked bar chart that I am trying to sort by the value of the measure. However, by default it keeps sorting the axis alphebetically by the names of the category on the axis. I know that I c...
Need Help
Tips and Tricks
  • markmess77's avatar
    markmess77
    2 years ago

    Looks like I found a workaround. So the field that I was previously using in the legend of the chart was from a dimension table. But if I joined the field directly into my fact table and used it from there, the sorting works fine. 

     

    Not sure what the technical reason is for the difference as the values are exactly the same, but at least I have the functionality that is required.

markmess77's avatar
markmess77
Resolver I
2 years ago

Looks like I found a workaround. So the field that I was previously using in the legend of the chart was from a dimension table. But if I joined the field directly into my fact table and used it from there, the sorting works fine. 

 

Not sure what the technical reason is for the difference as the values are exactly the same, but at least I have the functionality that is required.