Tooltip for Multiple Values in Clustered Column Chart

[bharri]

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

[v-stephen-msft · Accepted solution]

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.

[AlexisOlson]

What column(s) do you have on the x-axis?

[bharri]

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])).