Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Tooltip - Different Timeline Query

Hi guys,

 

I need help on the tooltip. I have a bar chart in a report page that displays the averages of the category based on its last 12 months. Now, I want to have a tooltip that compares current year vs previous year averages. However, when I do this, it only shows the last 12 months on the report page since the page is filtered to last 12 months. 

 

Is it possible to show comparison between current and previous year on a report page which have page filters applied to the last 12 months?

 

Thanks. 

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , If you are using a tooltip page then you can can avoid passing the time by switch off keep all filters and drag the required filters below it.

     

    Also with time intelligence you should be able to show last year same month or last period same month

     

    using a measure like

    Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

    Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

     

    try to create measures like below:

    CurrentYear = 
var _maxyear=MAXX(ALLSELECTED(Table1),'Table1'[Year])
var _r=
IF(HASONEVALUE(Table1[Year]),
CALCULATE(
    SUM(Table1[Sale]),'Table1'[Year]=SELECTEDVALUE(Table1[Year])),
CALCULATE(
    SUM(Table1[Sale]),'Table1'[Year]=_maxyear))
    return _r
    LastYear = 
var _maxyear=MAXX(ALLSELECTED(Table1),'Table1'[Year])-1
var _r=
IF(HASONEVALUE(Table1[Year]),
CALCULATE(
    SUM(Table1[Sale]),'Table1'[Year]=SELECTEDVALUE(Table1[Year])),
CALCULATE(
    SUM(Table1[Sale]),'Table1'[Year]=_maxyear))
    return _r

    Then create a tooltip page.

     

    Or instead of using the tooltip page, you can use the small multiples feature to display multiple years of data.

    Drag and drop the year field into the small multiples bucket.
    Select the year you want to display in the filter or slicer.

     

    Result:

    Please refer to the attachment below for details. 

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , If you are using a tooltip page then you can can avoid passing the time by switch off keep all filters and drag the required filters below it.

     

    Also with time intelligence you should be able to show last year same month or last period same month

     

    using a measure like

    Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

    Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, Anonymous 

     

    try to create measures like below:

    CurrentYear = 
var _maxyear=MAXX(ALLSELECTED(Table1),'Table1'[Year])
var _r=
IF(HASONEVALUE(Table1[Year]),
CALCULATE(
    SUM(Table1[Sale]),'Table1'[Year]=SELECTEDVALUE(Table1[Year])),
CALCULATE(
    SUM(Table1[Sale]),'Table1'[Year]=_maxyear))
    return _r
    LastYear = 
var _maxyear=MAXX(ALLSELECTED(Table1),'Table1'[Year])-1
var _r=
IF(HASONEVALUE(Table1[Year]),
CALCULATE(
    SUM(Table1[Sale]),'Table1'[Year]=SELECTEDVALUE(Table1[Year])),
CALCULATE(
    SUM(Table1[Sale]),'Table1'[Year]=_maxyear))
    return _r

    Then create a tooltip page.

     

    Or instead of using the tooltip page, you can use the small multiples feature to display multiple years of data.

    Drag and drop the year field into the small multiples bucket.
    Select the year you want to display in the filter or slicer.

     

    Result:

    Please refer to the attachment below for details. 

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.