Enable or Disable columns in a report

[EduardoMachado]

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.

[EduardoMachado]

Exactly, thank you very much @SamWiseOwl.

[SamWiseOwl · Accepted solution]

Hi @EduardoMachado 

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.