I need some help/idea/workaround on achieving the following -
I have a metrix visualization which shows few columns eg. Description, Asia Sales, Europe Sales, America Sales etc.
I have a slicer which has options like All Regions, Asia, America etc.
What I want to achieve is when All Regions are selected then show all the columns on the grid, When "Asia Sales" is selected then show only Asia Sales column, when multiple options from slicer is selected Eg. "Asia Sales" and "Europe Sales" then show those 2 columns next to each other and likewise
So basically want to hide a column based on slicer condition.