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

[Craig_Thomas]

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

[Anonymous]

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