Forum Discussion
Dynamically adding and removing columns on a table visual
Hi gpaltao ,
Believe that the option you need is to allow users to personalize visuals in a report:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals
With this option active you can have user make changes on the visualization of:
- Change the visualization type
- Swap out a measure or dimension
- Add or remove a legend
- Compare two or more measures
- Change aggregations, etc.
This can be active at a single visualization level, at a page level or at a full report level.
Any update on this topic? I DESPERATELY need some dynamic show/hide column functionality that is friendly for my users - the "Personalize" approach works, but isn't exactly intuitive for my audience.
Coming from a Qlik world, this was trivially easy to implement, which we did often, with good results. Surely the brains within Microsoft can build this in...?
Hi ctmullins,
Now there's is an option of field parameter that allow you to create a table with the fields you want or measures and the use a slicer to add or remove it from the visualizations.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters