Forum Discussion
Helper IHide or show Table visual columns based on another slicer selection/filter
Super UserHi tanehome1,
Try to explore Field Parameters -> https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in.
Another way could be to have different visuals and use buttons to show one or another depending on the user selection
Or you can use switch, but this won't work with columns but with DAX Measures -> https://learn.microsoft.com/en-us/dax/switch-function-dax
If you elaborate more on your request providing some sample data I could probably help more
If this helps, feel free to give kudos or accept as a solution 👍
Helper IThank you for your reply! I’m actually referring to an approach that uses a slicer not created by a Field Parameter, (which allows the user to select what to show in the table).
What I meant is similar to the example mentioned — to make it dynamic based on the type selection.
I appreciate the additional suggestions; the buttons and SWITCH examples are very helpful as well!
- danextian
Hi tanehome1
You can still use the field parameter table but you'll need create another with the information as to what columns are visible for each type. This also calls for a many to many relationship between the parameter and the view tables.
Please see the attached pbix
- tanehome1
Hi danextian,
thanks for your reply,
actually it works fine but i have to make another relation with the main table to show the related data accordingly.