Forum Discussion

TMASHELE's avatar
TMASHELE
Regular Visitor
2 years ago
Solved

dynamic columns in data tables or matrix

Hi everyone,

 

I have a business question. I have data for different units of a company (say retail, mortgage and cars). I want to make plots that are common across the units and some that are specific to the unit. I want to create a filter on the unit and when a user selects a unit, some specific fields are plotted for that unit (and will change based on the sector). This is because some fields will anyway be blank for other units (e.g. floor area would be filled in the mortgage but not in cars) so plotting them for all sectors would show blank plots when a non-relevant sector is selected.

 

Is there a way to do this? I know of the parameter solution that works only for table visuals (to show specific columns upon slicer selection).

 

Thanks everyone

5 Replies