Dynamic Column Visibility

[sabeensp]

Hello,

I need to show column dynamically in Grid or Matrix visual, I have a set of data with over 200 columns, but based on the slicer value selected, I only want to show the columns which have data. 

Example: User selectes the region "East" from Slicer and only "Sales" and "Local" Columns appear in the grid. How do I do that?

Apprecite yoru help.

[deldersveld · Accepted solution]

It's not currently possible to hide columns in a table or matrix based on selection. You could create a measure to display a blank value but not completely hide the column.

[sabeensp]

Thanks