Forum Discussion

bharri's avatar
bharri
Frequent Visitor
5 years ago
Solved

Tooltip for Multiple Values in Clustered Column Chart

Hi,

I have a clustered column chart which shows 2021 website pageviews against 2020 pageviews on a week-by-week basis.

The tooltip I have right now will show the top 3 webpages for a given week when hovering over the column, but it only shows the 2021 top 3 and not the 2020 top 3.

How can I tweak my tooltip to show the top 3 for both 2021 and 2020?

Any help would be greatly appreciated. Thank you.

 

Here's the DAX I have so far:

Top3Page =
VAR Top1 =
"1: "
& FILTER(VALUES('GA Data'[Page Title]),[PageRank]=1)
& " ("
& CALCULATE([Total Pageviews],FILTER(ALL('GA Data'[Page Title]),[PageRank]=1))
& ")"
& ", "
& UNICHAR(10)
VAR Top2 =
"2: "
& FILTER(VALUES('GA Data'[Page Title]),[PageRank]=2)
& " ("
& CALCULATE([Total Pageviews],FILTER(ALL('GA Data'[Page Title]),[PageRank]=2))
& ")"
& ", "
& UNICHAR(10)
VAR Top3 =
"3: "
& FILTER(VALUES('GA Data'[Page Title]),[PageRank]=3)
& " ("
& CALCULATE([Total Pageviews],FILTER(ALL('GA Data'[Page Title]),[PageRank]=3))
& ")"
RETURN
Top1 & Top2 & Top3
 
And here's what the chart looks like:
Pageviews
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi bharri ,

     

    Unfortunately, mentioned in the limitations and considerations, when choosing a field to be shown for report tooltips, when using a field versus a category, visuals that contain that field will only show the specified tooltip when summarization with the selected field matches.

     

    Therefore your request cannot be fulfilled.

     

    Best Regards,

    Stephen Tao

     

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

3 Replies

    • bharri's avatar
      bharri
      Frequent Visitor
      5 years ago

      The x-axis is a "Last day of Week" column from a Calendar table... 1/3/21, 1/10/21, 1/17/21 and so on. It's filtered to the relative date of This Year so the chart only shows YTD.

       

      The 2021 data comes from the measure Total Pageviews = SUM('GA Data'[Pageviews]). The 2020 data comes from the measure LY Pageviews = CALCULATE([Total Pageviews],SAMEPERIODLASTYEAR('Calendar'[Date])).

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi bharri ,

     

    Unfortunately, mentioned in the limitations and considerations, when choosing a field to be shown for report tooltips, when using a field versus a category, visuals that contain that field will only show the specified tooltip when summarization with the selected field matches.

     

    Therefore your request cannot be fulfilled.

     

    Best Regards,

    Stephen Tao

     

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