Matrix Visual – Sort by a Measure Without Showing It (Field Parameter in Use)

Hi NagaPushpa ,

The option you have since you are using a matrix is to reduce the size of the column in the matrix until is not visible (like you do in excel) drag and drop at header level, but be carefull that you need to turn off word wrap at column header and values.

Also be carefull that if a user clicks on top of any other column it will sort by that column:

Hi NagaPushpa,
Thank you for reaching out to the Microsoft fabric community forum. Thank you MFelix, for your inputs on this issue.
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.    

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.