Tooltip page

[newhopepdx]

A dashboard contains 5 line charts, one for each campus and I've used the same measure for each chart, adding a campus filter on each visual. I'm wanting to create a tooltip that can be used on each chart, but am not sure how to filter it like the visuals are filtered. Normally the tooltip would be filtered by a slicer that filters all the visuals, obviously that is not possible the way I'm doing it.

Any ideas??

Thanks

[KNP · Accepted solution]

@newhopepdx,

I still don't understand the problem.

I've made a short video for you. Have a look and explain how your scenario is different.

https://www.youtube.com/watch?v=qTZeh9QqWsQ

[newhopepdx]

Thanks to you both. As your video has made clear, I've clearly got something set wrong on the page that's causing what I'm seeing. I'll look the page over more carefully and see what I've goofed up.

[v-menakakota]

Hi @newhopepdx ,
Thank you for reaching out to the Microsoft Fabric community forum.

I also want to thank @KNP  and @danextian  for your active participation and the helpful solutions you've shared here. Your contributions truly make a difference.

Once you've had a chance to try, please reply back.

Thank you.

[v-menakakota]

Hi @newhopepdx ,

Can you please confirm whether the issue is sorted or not.

Thank you.

[danextian]

I'm wanting to create a tooltip that can be used on each chart, but am not sure how to filter it like the visuals are filtered.

This is unclear. If you use a visual filter, that filter propagates to the tooltip page. 

[KNP]

I can, can you give some more detail about the tooltip you're wanting to show?

[newhopepdx]

The five line charts each display the total attendance at a weekly event for a period that is specified by a date slicer. The charts are stacked vertically with other metrics above each one (so the small multiples option really won't work). They are identical, except that each is filtered (via each visual's filter pane) for one of the five campuses.

The tooltips should display the breakdown for attender category. I've no problem crafting the measure if it weren't for the weird filtering method I'm doing. As it is, the tooltip displays the total for all five campuses (since there isn't a campus slicer on the page, as that is handled individually on each chart visual).

[KNP]

Hi @newhopepdx,

Have you tried using small multiples?

It means you don't need the added complexity of visual level filters.

Alternatively, you could create measures specific to each visual and add all of those to your visual tooltip page.

The measure should be able to be set up to only show for the correct visual, but my first suggestion would be easier.

[newhopepdx]

The small multiples isn't a good fit for this particular dashboard design.

Could you explain a bit more on the type of measure that would work? Thx