topic Slicer values to be use in multiple column in DAX Commands and Tips

Slicer values to be use in multiple column

Anonymous — Wed, 08 Jul 2020 08:00:35 GMT

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", [?],

)

Re: Slicer values to be use in multiple column

nvprasad — Wed, 08 Jul 2020 13:29:36 GMT

Hi Anonymous ,

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

Re: Slicer values to be use in multiple column

Anonymous — Thu, 09 Jul 2020 01:26:22 GMT

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?