Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Everyone,
I have the following chart:
I am trying to add a tool tip such that when the user hovers over, let's say, December 2023, the tool tip chart shows both a bar for December 2023 and December 2022. So basically something like this:
Is this possible?
My tooltip page looks like this:
And here is the underlying dataset:
DateSales
January 1, 2021 | 100 |
February 1, 2021 | 120 |
March 1, 2021 | 150 |
April 1, 2021 | 130 |
May 1, 2021 | 120 |
June 1, 2021 | 150 |
July 1, 2021 | 160 |
August 1, 2021 | 165 |
September 1, 2021 | 170 |
October 1, 2021 | 155 |
November 1, 2021 | 180 |
December 1, 2021 | 132 |
January 1, 2022 | 164 |
February 1, 2022 | 198 |
March 1, 2022 | 154 |
April 1, 2022 | 145 |
May 1, 2022 | 162 |
June 1, 2022 | 132 |
July 1, 2022 | 139 |
August 1, 2022 | 254 |
September 1, 2022 | 201 |
October 1, 2022 | 230 |
November 1, 2022 | 235 |
December 1, 2022 | 236 |
January 1, 2023 | 239 |
February 1, 2023 | 246 |
March 1, 2023 | 258 |
April 1, 2023 | 245 |
May 1, 2023 | 269 |
June 1, 2023 | 299 |
July 1, 2023 | 289 |
August 1, 2023 | 247 |
September 1, 2023 | 265 |
October 1, 2023 | 230 |
November 1, 2023 | 220 |
December 1, 2023 | 100 |
Thank you, any help would much appreciated.
Solved! Go to Solution.
@Gladiator909 Check this blog:
Current & Previous Year Sales Based on a Selection... - Microsoft Fabric Community
@Gladiator909 Check this blog:
Current & Previous Year Sales Based on a Selection... - Microsoft Fabric Community
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.