Forum Discussion

jbhca12's avatar
jbhca12
Helper I
5 years ago
Solved

Sort Stacked Bar Chart by Data Value

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!

2 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    Hi jbhca12 

    in the visual you should see

     

    Sort by some of lables

     

    • jbhca12's avatar
      jbhca12
      Helper I

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