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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Alexxx
New Member

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Wowowo, easy on the sample data!  I have adjusted it to something more realistic.

 

lbendlin_0-1713819523629.png

 

Here's one possible implementation.

 

lbendlin_1-1713821497513.png

 

 

View solution in original post

2 REPLIES 2
Alexxx
New Member

@lbendlin Thank you very much!!! Works like a charm.

lbendlin
Super User
Super User

Wowowo, easy on the sample data!  I have adjusted it to something more realistic.

 

lbendlin_0-1713819523629.png

 

Here's one possible implementation.

 

lbendlin_1-1713821497513.png

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.