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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
tangutoori
Helper III
Helper III

show delta value

 

Prev NameCurrent name
123aabc
456bdef
  
  
  
  
ebom$ values
abc120
def100
123a50
456b80
789c90

am havign two tables.  change info, part name previous is changed to current values. secodn table have $ values for the old anf new parts. how can i show delta if i select current part. 

if i select abc in drop down list i should get 70 as result.

 

abc  
Prev NameCurrent nameDelta
123aabc70

 

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhj3Hjd6fYbfCxFGh?e=4vLMgM
1.png2.png3.png

View solution in original post

2 REPLIES 2
Ahmedx
Super User
Super User

and if you want to select a name in the slicer and show delta on the map, then you need to write the measure as follows:
Screen Capture #583.png

Ahmedx
Super User
Super User

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhj3Hjd6fYbfCxFGh?e=4vLMgM
1.png2.png3.png

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.