Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
PPalkowski
Helper II
Helper II

Column Slicer for table

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

image.png

 

 

 

 

 

 

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

 

Thanks!

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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
Super User
Super User
camargos88
Community Champion
Community Champion

@PPalkowski ,

 

Can you give an example of it ?

 

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.