How to align metrics in increasing order in table based on dimension selection

[Amit_Saxena]

Hi
Need help in DAX, I have pbi Table with coutry Dimension and few metrics (3) and based on user country selection all metrcis availabe in table should be align in ascending order from left to right based on thier ranking,for example : if user selected Country 'F' then whichever metrics among these three has high rank should be placed in first column then 2 then 3, here is an example based on user selection as 'F' country, QTY metrics should be first placed followed by Amount then Profit%, and if user changes the selection ofcountry then this order should be chnaged based on counrty whihc user has selected and it's ranking, metrics should aling in horizontally in increasing order from leftt right, pls suggest how would i align the metrics in ascending order for these metrics based on country slection, How can i place the metrics in order?

Here is the sample data and PBI:

sample PBI 

Country	QTY	Amount	Profit%	RANK_QTY	RANK_Amount	RANK_PROFIT
A	55	500	35%	4	4	3
B	20	700	45%	6	1	1
C	70	650	18%	2	2	6
D	70	600	40%	2	3	2
E	23	400	22%	5	5	4
F	81	200	20%	1	6	5

screen shot 

Thanks Amit

[lbendlin]

That is a rather tall ask. It's possible to do as long as you know how many measures are involved (for example when you always need to sort between three measures).

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...

But it would be MUCH easier to teach your users how to rearrange the visual content themselves, via the "Personalize Visual" feature.

[Amit_Saxena]

Thanks lbendlin for you reply and sharing this link, but this is slightly different and i need to think of how i can add the logic to use rank  these measures based on the selection of filter. slightly complicated for me, let me try and solve the ranking problem then aling the best rank column first in order based on region selection.  Appreciate your response!!