Forum Discussion
Helper IDisaplay martrix visual data in specific order
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
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
2 Replies
- PijushRoy
Community Champion
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 
VallirajapResolver III
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.