Forum Discussion
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 with their respective values.
test 1
test 2
test 3
test 4
test 5
In the table I only want to show the columns test1, test3 and test 5, the user does not have access to the data structure, so it needs to be something like a filter, but which allows the columns to be shown or not.
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.
2 Replies
- SamWiseOwl
Super User
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.
