Forum Discussion
Alexxx
2 years agoNew Member
Changing the reference data in a table with a slicer
| Car | Mass | Delta Mass |
| VW Beetle | 2000kg | 0 |
| Q7 | 2500kg | +500kg |
| BMW 3 series | 2200kg | +200kg |
Hello all,
I have a table like the one above. The delta Mass is now calculated using the VW Beetle as a reference.
Now I want to select the reference Car by picking it from a list (e.g. from a slicer).
So if I pick the Q7 for example it should look like this:
| Car | Mass | Delta Mass |
| VW Beetle | 2000kg | -500kg |
| Q7 | 2500kg | 0 |
| BMW 3 series | 2200kg | -300kg |
How is that done in Power BI?
Thanks for helping.
Alex
Wowowo, easy on the sample data! I have adjusted it to something more realistic.
Here's one possible implementation.