How can I add or remove columns dynamic in my matrix visual?

[Anonymous]

I have created a matrix visual in my repot - which is getting it's column values\data from different Measures I have created in the report data tables. 

I want to create a slicer which will have these different measure names as it's values and user can select which columns to display in the matrix visual at any point of time.

So if the user selects only Actual and Plan to show from the slicer the matrix should only display 3 columns (1 - Unit \ 2- Actual \ 3 - Plan). Rest of the columns should be hidden\removed from the matrix. 

  

[Anonymous]

Thanks @DataInsights  This solution solved part of my problem however I was just trying to see if there is anyway we can apply sorting\conditional formmatting on the added columns. I tried from my side but it seems like as everything is coming for a measure. 

[DataInsights]

@Anonymous,

Try this solution:

https://community.powerbi.com/t5/Desktop/Dynamic-column-selection-for-matrix-visual/m-p/687993