Forum Discussion

PshemekFLK's avatar
PshemekFLK
Icon for Helper IV rankHelper IV
8 years ago

Custom tooltip not working for grand total

Hello,   I have problems figuring out why the custom tooltip is not working for the Grand Total for the new measure ("Gap to Plan") in my matrix table.   The table shows Gap to Plan in dollar val...
Need Help
PshemekFLK's avatar
PshemekFLK
Icon for Helper IV rankHelper IV
8 years ago

Hi Maggie,

 

Correct. "Actual" and "Plan" are used in the tooltip. Both fields are from different tables connected by relationship. Again, the most confusing thing about this is that if I add another field to the table the tooltip starts to work on grand total. My feeling is that it has something to do with the dax formula for "Gap to Plan" but not sure. Please let me know if you need more info.

 

Thanks

 

 

PshemekFLK's avatar
PshemekFLK
Icon for Helper IV rankHelper IV
8 years ago

Hi v-juanli-msft

 

Below you can download a simple report with the problem described above: tooltip not working for total

 

https://ufile.io/b4qji

 

Can you look into it to see where it go wrong?

 

Thanks

 

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi PshemekFLK

    Please check the right table, it is a table visual instead of a matrix visual as the left one.

    This table show the same as your matrix, and it can show tooltip page correctly for the total.

     

    Best reagrds

    Maggie

    • PshemekFLK's avatar
      PshemekFLK
      Icon for Helper IV rankHelper IV
      8 years ago

       

      Hi v-juanli-msft

       

      The tooltip in the table in your file is visible but it's showing the wrong numbers (Category 56 instead of Total)

       

       

       

      Thanks,

      Przemek

       

       

      • PshemekFLK's avatar
        PshemekFLK
        Icon for Helper IV rankHelper IV
        8 years ago

        Can anyone help with the problem? It's a small thing but the tooltip on the total is really needed in the report

         

        Thanks