Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to 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.
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.
What column(s) do you have on the x-axis?
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])).