Forum Discussion

RobinH's avatar
RobinH
Helper I
7 years ago
Solved

Tooltip ignores Filter

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

  • 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.

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    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's avatar
      RobinH
      Helper I

      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's avatar
        v-juanli-msft
        Community Support

        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.