Forum Discussion
jonathansharp
4 years agoRegular Visitor
Percent change in tool tip
I have a report with a year slicer so different years can be compared, 2019 to 2021 for example. I wanto see the percent change between the two. I created the below measure and it shows correctly wh...
- 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)
jonathansharp
4 years agoRegular Visitor
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
Ashish_Mathur
Super User
4 years agoHi,
I tried but i cannot figure out a solution. Sorry