Use slicer to switch Columns in Matrix

[Denis_Slav]

Hi All, 

Maybe is there any way to resolve next issue without bookmarks?

I've got a tble with the set of columns. I'd like to use slicer to switch them in a matrix. 

I already tryied SWITCH, but I couldn't use this measure as column or rows.

[Denis_Slav · Accepted solution]

@Samarth_18 @v-henryk-mstf Thanks, but it's not what i'm looking for. 

I found solution to do what I want:

https://www.youtube.com/watch?v=dYmzb5UMkXw 

[v-henryk-mstf]

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.

[Samarth_18]

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%2... 

Thanks,

Samarth