Forum Discussion
Extension to filtering columns in a table
You can create a calculated column in the fields parameter table that categorizes the parameter value and use that in a slicer. Note: you can use this to select which columns visible but it won't work as expected if if both the calc and parameter columns are added in a visual.
Super User
You can create a calculated column in the fields parameter table that categorizes the parameter value and use that in a slicer. Note: you can use this to select which columns visible but it won't work as expected if if both the calc and parameter columns are added in a visual.
Thanks that does work, and it's almost there. What about if there are some parameters that are shared by categories. Let's say there was a metadata.name column that should apply to multiple categories. That I think wouldn't work with the solution you have here as you wouldn't be able to put multiple names in the category column.
Technically it would be possible to create a column like metadata.apple_name and metadata.banana_name but if you're gonna be working with 15+ categories, this would feel like a waste of space and lots of menial work.