Tooltips are not showing on Line Chart

[Anonymous]

I have a line chart visual in my report with 5 data fields under the Tooltips well. When I filter my report to last day or two (which is the most relevant time period for this dataset), my tooltips often disappear.

My data is set to Direct Query from a SQL Server. The X axis is a DateTime column from the queried table, and the Y axis is a measure calculating a running total of water consumption.

Tooltips:

Tooltips

Filtered to last 2 days:

Filtered to last two days

Filtered to last 4 days:

Filtered to last 4 days

[Agas]

Hi @Anonymous ,
When I don't see tooltips, it is generally because of the lack of data.
Are you sure that the fields you added to tooltips are not null for the last two days?
Your second line chart image shows the last four days line, but tooltips are there for the 29th of January.
Could you please check the 31st of January tooltips while you were filtering the last four days of data? (the second line chart image; move your cursor to the right on 31st)

Thanks,
Guven

[Anonymous]

@Agas ,

I do have tooltips for the 31st when filtering for the last 4 days. See Screenshot below. 

You may be on to something though--when I look at the data for the chart in focus mode filtered for last two days there is nothing under the tooltip fields, when I do the same thing filtered to last 4 days the table has a value in every cell...

Chart data filtered to last two days (empty)

Chart data filtered to last four days (filled)

[ibarrau]

Hi! It is like you are showing right there. There are two reason when you can't see your value in tooltip. The first one is that you have too much values and the can't fit in the box. The second one is that for that context you have a blank for the value.

It seems that you have the second reason.

Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

You're right, there are no values when filtered to 2 days, but that is not how it should be. The data exists in the queried table, and shows correctly in the chart table when filtered to >3 days. 

Take note of the timestamps in the table. Those from the one sorted to last 2 days correspond to those from the 4 day filtered table, but seem to have timestamps slightly after those in the actual data (approx. 1 second). I am sorting using the vanilla relative date slicer, why would the data change when all I am trying to do is filter?

[ibarrau · Accepted solution]

It is odd. Are you filtering the relative data of a Date Calendar Table? if you don't have a calendar table I'm not sure that the filter will work well. Unless you still have the auto-datetime time intelligence option of power bi.

Check the data. This is not a tooltip issue. I have mentioned the tooltip problems. If you have data in four last days and you don't in two last days it can be that you actually don't have in the last 2 days but the third one has. You should try to have your data always refreshed if you work with relative.

Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@ibarrau, you were right about the Date Calendar Table. I was previously filtering on a date column in the original dataset. I built a date table, filtered based on that one, and now the tooltips are functioning right. Thank you!