Overall % Change to a selected Date

Question

&nbsp;Hello,&nbsp;&nbsp;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 %.&nbsp;Overall % Change to a selected Date =&nbsp;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]))))

lbendlin · Answer

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.

lbendlin · Answer

Don't use SELECTEDVALUE inside CALCULATE.&nbsp; Use variables.
&nbsp;
Please provide sanitized sample data that fully covers your issue. https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Please show the expected outcome based on the sample data you provided. https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

kalkhudary · Answer

Hello Bendlin,&nbsp;Here is a sample of the data.&nbsp;DateProvinceCityNew Housing &amp; Residential TypePrice Index Value&nbsp;2017-01AlbertaEdmontonHouse only1002017-01AlbertaEdmontonLand only1002017-01AlbertaEdmontonCondo Only100.22017-04AlbertaEdmontonHouse only100.22017-04AlbertaEdmontonLand only99.42017-04AlbertaEdmontonCondo Only100.42017-07AlbertaEdmontonHouse only99.82017-07AlbertaEdmontonLand only99.92017-07AlbertaEdmontonCondo Only100.12017-10AlbertaEdmontonHouse only99.72017-10AlbertaEdmontonLand only1002017-10AlbertaEdmontonCondo Only99.32018-01AlbertaEdmontonHouse only99.72018-01AlbertaEdmontonLand only100.12018-01AlbertaEdmontonCondo Only98.62018-04AlbertaEdmontonHouse only99.32018-04AlbertaEdmontonLand only100.22018-04AlbertaEdmontonCondo Only97.92018-07AlbertaEdmontonHouse only99.52018-07AlbertaEdmontonLand only100.52018-07AlbertaEdmontonCondo Only97.62018-10AlbertaEdmontonHouse only992018-10AlbertaEdmontonLand only100.52018-10AlbertaEdmontonCondo Only94.7&nbsp;&nbsp;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.&nbsp;Hope I was able to explain it well. Would really appreciate your help on this.

lbendlin · Answer

see attached

kalkhudary · Answer

Hello Bendlin,&nbsp;&nbsp;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.&nbsp;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.&nbsp;What do you think?&nbsp;

Forum Discussion

Overall % Change to a selected Date

5 Replies

Related content

Change in category selection changes selected subcategory in slicers

Slicer selection button color change using native visual

Drive / change slicer selection based on value selected from a matrix

Calculation for Overall State

Donut chart to show overall % on selection of Slicer.

Date	Province	City	New Housing & Residential Type	Price Index Value
2017-01	Alberta	Edmonton	House only	100
2017-01	Alberta	Edmonton	Land only	100
2017-01	Alberta	Edmonton	Condo Only	100.2
2017-04	Alberta	Edmonton	House only	100.2
2017-04	Alberta	Edmonton	Land only	99.4
2017-04	Alberta	Edmonton	Condo Only	100.4
2017-07	Alberta	Edmonton	House only	99.8
2017-07	Alberta	Edmonton	Land only	99.9
2017-07	Alberta	Edmonton	Condo Only	100.1
2017-10	Alberta	Edmonton	House only	99.7
2017-10	Alberta	Edmonton	Land only	100
2017-10	Alberta	Edmonton	Condo Only	99.3
2018-01	Alberta	Edmonton	House only	99.7
2018-01	Alberta	Edmonton	Land only	100.1
2018-01	Alberta	Edmonton	Condo Only	98.6
2018-04	Alberta	Edmonton	House only	99.3
2018-04	Alberta	Edmonton	Land only	100.2
2018-04	Alberta	Edmonton	Condo Only	97.9
2018-07	Alberta	Edmonton	House only	99.5
2018-07	Alberta	Edmonton	Land only	100.5
2018-07	Alberta	Edmonton	Condo Only	97.6
2018-10	Alberta	Edmonton	House only	99
2018-10	Alberta	Edmonton	Land only	100.5
2018-10	Alberta	Edmonton	Condo Only	94.7