Sort a set of gauge dials in ASC/DESC order dynamically when dates are selected by slicer?

[Anonymous]

I have a set of dials that display certain values taken from various locations.

Now with the relative date slicer on the same page , the selection of dates will provide different values from each location/dials.

For example : As a sample , I have set 6 dials taken from 6 locations (A to F). I have made a sample database where records starts from 1st Jan 2021 to current day (22nd Feb 2021) which has records of values (imagine value to be something like sales % of mobile phones sold at these locations). The below selection is for This month. 

Now as you can see , the dials from all 6 locations are different. My task is to re-arrange/sort them in ASC order. So , my expected output for the same "This Month" selection should be something like this :

Order is now : F,C,A,D,E,B as 12.67<12.68<14.97<17.83<18.02<31.00.
Likewise , If I select for Last 2 weeks , I expect the dials to be arranged this way :

So, ergo my question is : How to Sort a set of gauge dials in ASC/DESC order dynamically when dates are selected by slicer?

I have been stuck at this for week and a half.

APPROACH I HAVE TAKEN :
I had some idea of creating a diff table with 2 cols : Location and Values
Where Location column contains all the 6 locations and the Values simply depict the values corresponding to dial and the dial selection. Meaning while the selection is on "This Month", my Table should be like this :

or like this if Last 2 Weeks are selected:

But I later learned that columns DO NOT CHANGE DYNAMICALLY, they are static !

The data stored here under the Values column are without the effect of the relative date slicer.

If it weren't for this , I would have simply made an index column that will index the data under Value in ASC order. Rest will be simply assigning the values from the lowest vlaue (index 1) to 1st dial to the highest vlaue (index 6) to 6th/last dial.

Any help will be greatly appreciated . Thnx!

[PhilipTreacy]

Hi @Anonymous 

On the face of it this seesm doable but my head hurts trying to imagine the data. Can you please supply some sample data and explain how you want to calculate your results.

Regards

Phil

[Anonymous]

Hey , thanks for the reply. I have re-edited my question for an easier explanation