Sort Stacked Bar Chart by Data Value

[jbhca12]

Howdy,

I've seen posts about this and maybe I am missing something but I am attempting to sort my stacked bar chart based on the data labels which are calculated based on the filter criteria when the slicer filtering is applied. 

Values: Duration (hour) is SUMmed

So as you can see by the above, the Category can change depending on the machine, the scheduled/unscheduled downtime and the start and end date range (that is the filter criteria). The downtime in hours is summed based on the records selected based on the filter criteria.

I've seen solutions that suggest creating another column in the table to perform a sort on a numeric value. But based on the example above, 0.33 for 5S, 0.17 for Reel Change and 8.05 for Setup Time, these values are summed from the detail records selected based on the filter criteria. How would I go about sorting it such that 8.05 is on the top and 0.17 is on the bottom?

Thanks!

[aj1973 · Accepted solution]

Hi @jbhca12 

in the visual you should see

Sort by some of lables

[jbhca12]

Yup, was just about to re-post, "Never mind, found it!"