Use slicer to switch Columns in Matrix

Hi Denis_Slav ,

 

You could refer to below article.

 

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/#:~:text=Click%20on%20Conditional%20formatting%2C%20Select,The%20visual%20to%20show%2Fhide. 

 

Thanks,

Samarth

 

Hi Denis_Slav ,

 

Generally speaking, slicer as a filter to filter the object is row, can not dynamically filter column, but I think you can create a button, combined with the function of bookmark, display the same effect, reference the following:

Selected column = 
SWITCH(
  SELECTEDVALUE(Slicer_column[slicer_])
   ,"Column1",SUM(Sales[Column1])
   ,"Column2",SUM(Sales[Column2])
   ,"Column3",Sum(Sales[Column3])
   ,BLANK()
)

click button1

click button2

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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