Forum Discussion

bmcminn's avatar
bmcminn
Icon for Helper II rankHelper II
3 years ago
Solved

Sort bar chart using value not included in chart

I want to sort the chart by Total Cost, but not have that value show up in the legend. So either not have it as part of the visualization or hide it from the legend, whichever is easiest.

Thanks!

This one doesn't include the Total Cost in the x-axis and is not sorted how I want.





 


This one includes Total Cost in the x-axis. It is sorted correctly, but I don't want to see Total Cost in the legend.

 

Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    i'm not sure if this will work for you but if you create a calculated column to sum the total then use this in the tool tip you can select the ... at the top of the chart and use sort axis to sort by the new column.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

2 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi,

     

    i'm not sure if this will work for you but if you create a calculated column to sum the total then use this in the tool tip you can select the ... at the top of the chart and use sort axis to sort by the new column.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    • bmcminn's avatar
      bmcminn
      Icon for Helper II rankHelper II
      3 years ago

      I didn't even need to make a calculated column. I just put the measure into Tooltips and was able to see Total Cost under Sort By!

       

      Thanks!