Column Slicer for table

[PPalkowski]

Is there a way to create a slicer that would change the first column of a table?

I would love to be able to have whoever is viewing the table to have the abilty to switch between Employee and Manager

Thanks!

[v-shex-msft · Accepted solution]

Hi @PPalkowski,

Measure formula is possible to achieve switch fields value between multiple fields but it not able to use as category to aggregate or summarize values.

For your requirement, I'd like to suggest you take a look at the following link to achieve a dynamic attribute filter.

Dynamic Attributes In A Power BI Report 
Regards,

Xiaoxin Sheng

[amitchandak]

Refer :https://community.powerbi.com/t5/Desktop/dynamic-title/m-p/969313/highlight/false#M464103

https://community.powerbi.com/t5/Desktop/Dynamic-Variable-Column-Header-Names-Changing-with-Slicer/t...

[camargos88]

@PPalkowski ,

Can you give an example of it ?

Ricardo