Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |