Forum Discussion
Helper IVOverall % Change to a selected Date
Super UserDon't use SELECTEDVALUE inside CALCULATE. Use variables.
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
kalkhudaryHello Bendlin,
Here is a sample of the data.
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 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.
- lbendlin
see attached
- kalkhudary
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?