Forum Discussion
Solved
Enable or Disable columns in a report
I want to allow the user to activate or deactivate columns in the table visual, something like a filter in which they select which columns they want to see in the report The Fact table has 5 columns...
Have you tried Field Parameters?: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Here my user tickets the columns they want to see in the table.
With 2 columns that always appear regardless.
To create them go to Modelling | Field Parameters
If they are columns you can just drag them in.
When using Aggregates like SUM(this field) or Count(that field) you must make them as measures first.
You can tell the field is a measure due to the calculator icon.
Exactly, thank you very much SamWiseOwl.