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
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi PshemekFLK

I can't reproduce your problem.

the columns added to Tooltips page are "Actual" and "Plan" columns, right?

 

Best Regards

Maggie

 

 

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