Solved: Column Slicer for table

PPalkowski · ‎04-02-2020

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 · ‎04-02-2020

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

v-shex-msft · ‎04-02-2020

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

amitchandak · ‎04-02-2020

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...

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!