Stacked Column Chart Tooltip Video and Demo .pbix included

Hello EDNA Community

Good Day!

Attachment:

Demo .pbix
PBIXDD Stacked Column Chart EDNAF_SCLC.pbix (1.4 MB)

Video
https://vimeo.com/627845664/c7c58ea9f1

Hello @ambidextrousmentally,

please see if attached fulfills your needs.

I replaced SAMEPERIODLASTYEAR with DATEADD to fix the September not showing issue.
Then added the PY measure to your tooltip site and removed the “keep all filters” now you see both years in the tooltip, otherwise it just shows the year you are hovering over.
File attached for reference.

Cheers,
Seb



PBIXDD Stacked Column Chart EDNAF_SCLC.pbix (1.4 MB)

Hello Seb

I found the solution to part two of my video.

Adding two screen shots showing how I got the line chart in the tooltip to tie to the stacked column chart visual.


image

Much appreciate your help and the quick response per this matter.

Many thanks and regards,

Best

1 Like

Seb

Where was the keep all filters you removed on my tooltip site?

I replaced SAMEPERIODLASTYEAR with DATEADD to fix the September not showing issue.

Then added the PY measure to your tooltip site and *removed the “keep all filters now you see both years in the tooltip, otherwise it just shows the year you are hovering over.

File attached for reference.

Hello @ambidextrousmentally,

please have a closer look on the second snippet I attached in my original post, there you find the “keep all filters” tooltip button I switched off marked in yellow on the right.

Cheers,
Seb