Tooltip ignores Filter

[RobinH]

Hey Everyone

I have a Report with a Tooltip. (stacked column chart)

The idea would be that i see the sum by Geo Region (as in the picture).

My Problem is each visual have a filter for a specific Stream (left upper corner).

But the tooltip shows the values of all streams and not just the selected one for this Visual.

If a activate "keep all filters" the tooltip shows me the valuesof ever region and not the sum of all.

Thank you for your assistance.

regards
Robin

[v-juanli-msft]

Hi @RobinH 

This is my tooptip with "Keep all filters" on and a correct summarization "count" in my scenario.

Then add this as a tooltip page for stacked column charts, it shows correctly as below (the table show the values of tooltip when hovering the column)

"tooltip shows me the valuesof ever region and not the sum of all"

Could you show me expect output with some example data?

I believe it could be resloved by creating new measures.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RobinH]

Hi @v-juanli-msft 

Thank you for your feedback.

I created a sample file:

I would like to see the summ of all Regions sorted by Geo Region.

As you can see i have 2 visuals just filtered by Stream (Private and Business).

The tooltip shows at the moment the value of all id's, but i also need it filtered by Stream depents on the visual.

I hope you get my idea.

Best Regards

Robin

[v-juanli-msft · Accepted solution]

Hi @RobinH 

Turn on "Keep all filters" on two pages (main report page and tooltip report page).

Then it works on two visuals.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.