Stacked Column Chart Tooltip Video and Demo .pbix included

DAX DAX Calculations
1

Hello EDNA Community

Good Day!

Attachment:

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

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

2

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

Snippet 1
Snippet 11887Ă—1109 163 KB

Snippet 2
Snippet 23354Ă—1355 226 KB

PBIXDD Stacked Column Chart EDNAF_SCLC.pbix (1.4 MB)

3

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
image1692Ă—972 82.3 KB

image

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

Many thanks and regards,

Best

1 Like
4

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.

5

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