Forum Discussion

jonathansharp's avatar
jonathansharp
Regular Visitor
4 years ago
Solved

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...
Need Help
  • jonathansharp's avatar
    jonathansharp
    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's avatar
jonathansharp
Regular Visitor
4 years ago

Hi Ashish,  I am new to posting thing here so please forgive my ignorance.  How to I share the link while making sure I am not sharing any company data?  Also this PBI is getting its data from a seperate model that you wouldn't have access to, so would you even be able to view anything on the report?

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

You will have to anonymise the data and then share it with me.  I am not sure of how much i can help, but i would like to try.

  • jonathansharp's avatar
    jonathansharp
    Regular Visitor
    4 years ago

    The data source is a tabular model deployed to our Power BI premium workspace.  Would anonymising mean creating a copy of the model within this report but with dummy data? Please forgive my ingnorance, I am just new enough to power bi to be unsure on this point.