Forum Discussion

id013's avatar
id013
Helper V
6 years ago
Solved

Tooltip for Stacked Column Chart

Hi,

So I have a stacked column chart that has values color coded by groupings. So when I mouse over the chart, the tooltip only shows the value for the group I am currently mousing over. Is there a way to make the tooltip show the value for all the groups when I mouse over any portion of the chart? I have attached a highely redacted screenshot to illustrate 🙂 

So for the fiscal period I've selected it only shows my the value of 10 which is the value for group 1, is there a way so that if I mouse over any portion of that column it will show me all values for all groups?

Thanks

Need Help
  • OwenAuger's avatar
    OwenAuger
    6 years ago

    Hi there,

     

    It looks like you can do this if you use a Report Page Tooltip but not a regular tooltip.

     

    I have shared a PBIX here with a very simple example.

     

    The key thing is to set up the Tooltip Report Page so that the Keep all filters = Off and the filter you want to be passed (e.g. Fiscal Period) dragged to the Tooltip fields well.

     

    Then only the Fiscal Period will be passed through as a filter to the tooltip.

     

     

     

    Are you able to get that working in your case?

     

    Regards,

    Owen

7 Replies

  • OwenAuger's avatar
    OwenAuger
    Super User
    6 years ago

    Hi there,

     

    It looks like you can do this if you use a Report Page Tooltip but not a regular tooltip.

     

    I have shared a PBIX here with a very simple example.

     

    The key thing is to set up the Tooltip Report Page so that the Keep all filters = Off and the filter you want to be passed (e.g. Fiscal Period) dragged to the Tooltip fields well.

     

    Then only the Fiscal Period will be passed through as a filter to the tooltip.

     

     

     

    Are you able to get that working in your case?

     

    Regards,

    Owen

    • id013's avatar
      id013
      Helper V
      6 years ago

      OwenAuger 

      Thank You !!!! This solution worked magnificently. Thanks. One thing I did notice though that when I drag the fiscal period fields into the tooltip fields, all the visuals that have tooltip set to report page -> auto now display the new tooltip instead of the default. Is that normal? Either way I can get around it by setting those to default instead but I was just curious if that's a bug or on purpose.

      • OwenAuger's avatar
        OwenAuger
        Super User
        6 years ago

        id013 Glad that worked for you 🙂

         

        I expect that's meant to be a "helpful" behaviour, but I can see that it might not be desirable.

        It may depend on which fields are present in the visual(?)

        Yes I expect you are stuck having to change to default manually.

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi id013 ,

     

    We can create a measure and use it in tooltips field to meet your requirement:

     

    Tooltips Measure = 
CONCATENATEX (
    SUMMARIZE (
        CALCULATETABLE (
            DISTINCT ( 'Table'[Legand] ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[X-axis]
                    IN FILTERS ( 'Table'[X-axis] )
            )
        ),
        'Table'[Legand],
        "TotalValue", CALCULATE (
            SUM ( 'Table'[Value] )
        )
    ),
    [Legand] & ": " & [TotalValue]
        & UNICHAR ( 10 )
)

     


    Best regards,

     

    • id013's avatar
      id013
      Helper V
      6 years ago

      v-lid-msft 

      Thank you very much for your suggestion. I will keep that in mind for other situations but in this case I felt the other suggestion would be easier to implement as I don't want to be creating too many measures in this case.

       

      • SvenW's avatar
        SvenW
        Advocate I
        3 years ago

        Hi Shruthi96 , were you ever still able to get the percentage beside the total value? I am struggling with the same issue and would like to know if (and how) you solved it. Many thanks.