Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Tooltip is separating the data on hover

Greetings, 

 

Another problem encoutnered, this time it's a tooltip one. As you can see below, the tooltip is separating the data on hover. In other words, takes the line chart as a different data type, whereas it's just a cumulative measure. Any ideas how to merge the two? 

 

This is what is shown when I hover over the Session columns: 

 

This is what is shown when I hover over Sessions Cumulative: 

 

I would like it to be merged just like here: 

 

Looking forward to your ideas! 

 

 

  • Hi Anonymous ,

     

    Tooltips are based on the data point you are presenting so in your case when you click on the column you get the value of the column and on the line the respective value. Altough you can add other values to the tooltip allowing to have more fields visible in this type of chart it's only valid for the columns:

     

     

     

    the option is to add a custom tooltip with both values:

     

    I added a multirow card to the tooltip but is just depending on your imagination.

     

    https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

9 Replies

  • Hi Anonymous ,

     

    Tooltips are based on the data point you are presenting so in your case when you click on the column you get the value of the column and on the line the respective value. Altough you can add other values to the tooltip allowing to have more fields visible in this type of chart it's only valid for the columns:

     

     

     

    the option is to add a custom tooltip with both values:

     

    I added a multirow card to the tooltip but is just depending on your imagination.

     

    https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

  • Anonymous ,

    Try to add that measures which you want at same glance under tooltip option.

  • negi007's avatar
    negi007
    Community Champion

    Anonymous I think you can include both the data values in both charts in the tooltip box. This way both tooltip appear whichiver chart is selected or you move mouse over.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Many thanks for your answers! Since all you power users have flocked here, I have got one more question related to custom tooltips. I tried using it for the Sessions and Cumulative Sessions metrics. However the Sessions Cumulative always showed me the same value as Total Session. 

      My assumption is, the tooltip is filtered by a specific date, is there any way to overcome this issue? 

       

      This is the formula I use for Cumulative Sessions: 

       

      Total Sessions cumulative = 
          CALCULATE(SUM([Sessions]),
          FILTER(ALLSELECTED('Calendar'),
          'Calendar'[DateKey]<= MAX('Calendar'[DateKey])))

       

      Looking forward to your answers! 

      amitchandak MFelix Tahreem24 negi007 

       

       

      • MFelix's avatar
        MFelix
        Super User

        Hi Anonymous, 

         

        In theory using the same measure has you use on your visualization the filter context should be kept.

         

        This is related with context, since you are using the allselected the information is getting filtered by the selected value, you need to add the date context to your tooltip page, or using a new measure to chan ge the ALLSELECTED.