Forum Discussion
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
- amitchandakSuper User
Anonymous , Not very clear. Hope both are different measure you can correct formatting in measure/column tool.
In case it not showing combined tooltip and you want one you have tooltip pages
- MFelixSuper User
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
- Tahreem24Super User
Anonymous ,
Try to add that measures which you want at same glance under tooltip option.
- negi007Community 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.
- AnonymousNot 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
- MFelixSuper 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.