Forum Discussion

stsmith67's avatar
stsmith67
Frequent Visitor
3 years ago

Change Table Columns Based on Slicer Selection

Hi All,   I'm looking for a way to switch out columns in a table if a selection from a slicer is made. Example Year Slicer = 2021, show Columns A, B and C in my table or if Year Slicer = 2022, s...
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
3 years ago

The "Switch" function checks the selected value of the slicer and returns the appropriate set of columns using the "SelectColumns" function. If no value is selected in the slicer, the formula returns BLANK().

 

You can then use the "Selected Columns" measure in your table visualization instead of selecting the columns directly. When you change the value in the slicer, the columns displayed in the table will update automatically based on the selected year.

 

Let me know if you might need further guidance.

elaine1217's avatar
elaine1217
Icon for Helper I rankHelper I
3 years ago

Hi, 

 

I also am trying to do this and got the same error as above about the multiple values not being converted to scalar value. Your response explained how it works but didn't really answer why this error would occur. Do you know why we would be getting this error?

 

Thanks!