Forum Discussion
Percent change in tool tip
- 4 years ago
I figured out a solution. Not the most elegant, but gets it done. I removed the year from the column series and then created two measures to look at leads from the first year and last year like below. This gets the tool tip to show the change between the two. The only down side is that now more then two year's can't be viewed at once.
First Year Leads = VAR minyear = Dim_Date[minyear] RETURN CALCULATE(Fact_Lead[Count Lead],Dim_Date[Year] = minyear)
Ashish_Mathur Here is a link to the file. I won't let me attach it here for some reason. I am getting this when I try.
https://drive.google.com/file/d/1eLAXdSpmBgez7iMs2fyznzvP3ZQ8GtU9/view?usp=sharing
Anonymous - I uploaded a copy of my report above. Do you have any ideas of how to make it pass both the first and second year into the tool tip?