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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III
Helper III

Overall % Change to a selected Date




I am looking to get the % change to a selected date in a line chart. I am have wrote this dax function but it is not retreiving anything.Not sure what I went wrong here to get the difference between the selected location price index to subtract it from the original min price index on that visual. Then probably divide that by the miniumn price index as well to get the %.


Overall % Change to a selected Date =


Calculate (AVERAGE(Dim_New_Home_Price_Index[Price Index Value],selectedvalue(Calendar[Date])) - Calculate (average (Dim_New_Home_Price_Index[Price Index Value ]), min(Calendar[Date]))))

Super User
Super User

Don't use SELECTEDVALUE inside CALCULATE.  Use variables.


Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

Hello Bendlin, 

Here is a sample of the data. 

DateProvinceCityNew Housing & Residential TypePrice Index Value 
2017-01AlbertaEdmontonHouse only100
2017-01AlbertaEdmontonLand only100
2017-01AlbertaEdmontonCondo Only100.2
2017-04AlbertaEdmontonHouse only100.2
2017-04AlbertaEdmontonLand only99.4
2017-04AlbertaEdmontonCondo Only100.4
2017-07AlbertaEdmontonHouse only99.8
2017-07AlbertaEdmontonLand only99.9
2017-07AlbertaEdmontonCondo Only100.1
2017-10AlbertaEdmontonHouse only99.7
2017-10AlbertaEdmontonLand only100
2017-10AlbertaEdmontonCondo Only99.3
2018-01AlbertaEdmontonHouse only99.7
2018-01AlbertaEdmontonLand only100.1
2018-01AlbertaEdmontonCondo Only98.6
2018-04AlbertaEdmontonHouse only99.3
2018-04AlbertaEdmontonLand only100.2
2018-04AlbertaEdmontonCondo Only97.9
2018-07AlbertaEdmontonHouse only99.5
2018-07AlbertaEdmontonLand only100.5
2018-07AlbertaEdmontonCondo Only97.6
2018-10AlbertaEdmontonHouse only99
2018-10AlbertaEdmontonLand only100.5
2018-10AlbertaEdmontonCondo Only94.7


Annotation 2022-12-03 142749.pngAnnotation 2022-12-03 142858.png


When I click on one part of the line, it will show me in the card above, the %change from 2017 to the date clicked on in the visual.


Hope I was able to explain it well. Would really appreciate your help on this.


see attached

Hello Bendlin, 


I have tried this equation but did not yield the subraction that we need. I was looking what is the problem but seems it is not reading the min date value when we click on the visual.


When I cick on a particular point on the line visual, It is giving me the date, I clicked on and not 2017 the min date. In this condition, giving me the subraction as "0" and not for example 120 -100 = 20 as a numerator. Not sure what we need to adjust in the min date dax. The rest of equation is correct.


What do you think?


That's an interesting issue. When you click on the datapoint you are now setting the filter context so that the min and max range is the same as the clicked value. That means you need to provide your desired min value from a different, disconnected table.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors