Tooltip is separating the data on hover

[Anonymous]

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! 

[negi007]

@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]

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 

[Tahreem24]

@Anonymous,

Could you please share the sample data that you are using for Cumulative Total?

[Anonymous]

@Tahreem24  unfortunately, I can't share the file, as it's confidential. 

Here are some screenshots of the data columns used: 

1. DataKey- Dates Table created through Power Query 

2. Sessions extracted from Google Analytics connector (the original one) 

[Tahreem24]

@AndrejBI ,

I asked for sample data not the actual data.

Well, in order to calculate cummulative total try the below DAX:

Column Cumuative Total =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    ALL ( 'DateTable' ),
    'DateTable'[Date] <= EARLIER ( 'DateTable'[Date] )
)

Measure:

Running Total MEASURE = 
CALCULATE (
    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),
    FILTER (
        ALL ( 'All Web Site Data (2)' ),
        'All Web Site Data (2)'[Date] <= MAX ( 'All Web Site Data (2)'[Date] )
    )
)

[MFelix]

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.

[Tahreem24]

@Anonymous ,

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

[MFelix · Accepted solution]

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

[amitchandak]

@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

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