Forum Discussion

Alexxx's avatar
Alexxx
New Member
2 years ago
Solved

Changing the reference data in a table with a slicer

CarMassDelta Mass
VW Beetle2000kg0
Q72500kg+500kg
BMW 3 series2200kg+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:

 

CarMassDelta Mass
VW Beetle2000kg-500kg
Q72500kg0
BMW 3 series2200kg

-300kg

 

How is that done in Power BI?

Thanks for helping.

Alex

2 Replies