Sort bar chart using value not included in chart

[bmcminn]

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.

[DOLEARY85 · Accepted solution]

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]

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!