Dynamic value selection for Matrix

[Anonymous]

Hi, 

I have a matrix of around 30 rows and 10 columns, with a corresponding value for each row/column combination. I have created around 5 measures which I'd like to show as the 'values' for the matrix.

However, it becomes unreadable quite quickly if I show all 5 measures at once. Instead, I'd like to enable the user to dynamically choose which measure they want to view in the 'values' section of the matrix. 

Is this possible? If so, how? 

[amitchandak · Accepted solution]

@Anonymous , I think measure slicer can help .

refer to my video: measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M

or
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

[Anonymous]

This is brilliant thanks @amitchandak!