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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Craig_Thomas
New Member

Can you use a Slicer to modify data instead of filtering it?

Hello all, 

 

We have a challenge with a dashboard that is client facing. This dashboard rates clients (in this instance, our suppliers) based on some key financial metric. The tricky part is that we wish for the rankings to remain anonymous so "Supplier A" cannot look for specifically "Supplier B". 

 

Therefore, is it possible to use a Slicer as a modifier to (instead of filtering to the selected value) act like an IF statement and change the suppliers names based on the selection? 

 

For example, this is what I would like to achieve

 

Matrix Table

 

Original Supplier      Spend        

Bob's DIY                    150.00

Tony Hardware           140.00

John's Tool Stop         120.00

Jared's Odd Job          110.00

 

Slicer Selected Value: John's Tool Stop

 

Updated Supplier      Spend        

Supplier                      150.00

Supplier                      140.00

John's Tool Stop         120.00

Supplier                      110.00

 

Note that the slicer selections does not filter to only "John's Tool Stop" but modified the data instead. 

 

Is this possible on PBI? 

 

Thanks, 

Craig

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @Craig_Thomas,

 

Nope, calculated column/table can't be dynamic based slicer/filter. Measure is possible to use slicer to dynamic replace value, but it can't works as axis or group column.

 

Maybe you can try to add other column as index/group column, then use measure to check and replace matched values.

 

Regards,

Xiaoxin Sheng

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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