Change matrix based on filter

[poweruser55]

Is there a way to add columns to a matrix and take them away by using filters. So for example if I had a filter called products with A, B and C and chose products a and b the matrix would only show a and b for the columns. So I want the users to be able to choose the columns they see in the matrix. 

[v-chenwuz-msft]

Hi @poweruser55 ,

You can try slicer visual in power bi. 

If the end user selected product A, and the matrix table will only show the product A.

Slicers in Power BI - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[poweruser55]

Yes, but that is not what I am trying to do. I want to combine multiple products into one column while also showing the other colums @v-chenwuz-msft 

[ribisht17]

Hi ,

Please check this Solved: Dynamically change columns in Matrix - Microsoft Power BI Community community post

Regards,

Ritesh

Please mark the answer if it helps you so that it can help others as well

[poweruser55]

I am not sure that is the same thing. I want to combine products into one field giving one number instead of seeing them separately, I know I can do this in the transform data but I don't know what formula I would use. @ribisht17