Disaplay martrix visual data in specific order

[Ashok_Gopeani]

Hi Team,

i have implemented my dash board with mitrix visual and hierarchy visual, Matrix data will be display on seletion of slicer like below

but i need to display rating values like below

AA

A

BB

B

i am attaching my pbix file here. could you please verify and let me know solution

https://drive.google.com/drive/folders/1E3z9e6HRRknQlcdIfmtsb-dJb72q5kQ6?usp=drive_link

[PijushRoy · Accepted solution]

Hi @Ashok_Gopeani 

Please find the PBIX file link
https://drive.google.com/file/d/13QlMDrip-GgqM_9iEHcSmzKGqw7kmNAi/view?usp=sharing

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Vallirajap]

Hi @Ashok_Gopeani, 

You can create an index based on the prime value and sort the rating column using that index.
Index Dax:

Index =IF(LEFT(Country[Prime],1) = "1", 1,IF(LEFT(Country[Prime],1) = "2", 2,IF(LEFT(Country[Prime],1) = "3", 3+1, 4-1)))

Using the above index column to sort the rating, refer to the below image.

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you.