Sorting chart without visualizing data being sorted

[Anonymous]

Hi all! My data is set up as below. Column 2 is just a placeholder for a bunch of columns that are not currently relevant. Abs Diff (or Absolute Difference) is the combined distance of Max and Min from Mean. So for Row 1, its |7 - 3| + |9 - 7| = 6. The Max and Min % Diff are just the percentage of the difference from the Mean. So for Row 2, Max % Diff is (9 - 2)/7 = 28%.

Month	Category	Column 2	Name	Min	Mean	Max	Abs Diff	Max % Diff	Min % Diff
Jan 2022	A	adjasda	Item_X	5	5	10	5	100%	0%
Feb 2022	B	afnsaofs	Item_Y	3	7	9	6	28%	-57%
Mar 2022	C	fdoshfsi	Item_Z	2	6	6	4	0%	-66%

I am plotting this on a stacked bar chart with the Name as the y-axis, Min and Max % Diff as the x-axis, and the Month and Category in slicers. The result is somewhat of a diverging bar chart, as seen below. 

What I want to do is sort the chart by Abs Diff. I have tried sorting the Name column by the Abs Diff column, but I always get the error saying that you cannot sort by column if multiple values exist in one column for one value in the other. Any thoughts about how I could go about sorting this? 

[jdbuchanan71 · Accepted solution]

@Anonymous 

If you add the ABS Dif to the tooltip on the visual you can then use it to sort the visual.  In my example I am showing paid amount by Member ID but I have added co-pay to the tooltip so I can sort the chart by co-pay amount.

[Anonymous]

Worked like a charm, an absolute genius trick. Thank you good sir.