Switching between Text Columns

[CEllis]

I feel this should be very easy but cant find the syntax.

I have 2 text columns [Name] and [Number]

I want to use a slicer to swap the [Name] for the [Number] to anonymise the data.

Many thanks

Chris

[Anonymous · Accepted solution]

Hi @CEllis ,

Hope all is going well.

To dynamically switch columns, you can use field parameters, which is a preview function. The specific steps are as follows:

Enable field parameters in File>>Options.

Select New Parameter>>Fileds on the Modeling tab under the Report view.

Select the fields you want to apply as shown in the figure below. In this case, select "Name" and "Number" of the "Table" table.

Drag the Parameter you created into the table visual to display it.

Now you can select different items in Slicer to display different columns to achieve dynamic switching of columns.

If you want to know more about field parameters, please refer to the following documentation link.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn [c3...

pbix file is attached.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[CEllis]

@Anonymous 

Fantastic works brilliantly, much appreciated.

[Syk]

If the number is on the same row as the name, just put the number into the slicer.

If not, can you share a bit more about your data/model?

[CEllis]

I have the name in a lot of charts and tables and would like to be able to swap it dynamically when needing to demostrate to those who are not allowed to see the names.

TableNameNumber

Name	Number
David	1
Paul	2
Katy	3
Fred	4
George	5

If a slicer selection was "Yes" swap the Name for the Number.