Slicer values to be use in multiple column

[JWick1969]

Hi everyone,

I'm working to create slicer for multiple columns. my Slicer value are A,B & C. if i choose A in slicer, i wanted to display the related records to table and  stacked bar chart so on.  Instead of creating different  chart and table for inputA, InputB and InputC  I would only use one for both visualization. the values would be change based on the slicer.

I'm trying to use the code below and could not get the column name.

Thank you in advance.

Measure

Slicer DEFECT =
VAR selection = SELECTEDVALUE(SlicerTable[input])
return SWITCH(TRUE(),
selection = "A",[?],
selection = "B", [?],
selection = "C", [?],

)

[nvprasad]

Hi @JWick1969 ,

You can use bookmarks instead of using slicer in this case. by changing column for each bookmark you can arrive this easily.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[JWick1969]

Thank you for the suggestion. do I need to create 5 separate pages to determine those particular input. So, i can use slicer or button to dsplay the page. This is what you mean? How can i change the column?