Main page adds unwanted date/time context to tooltip

[FabricNJ]

Edit 4/9/2025

A solution and a conclusion

Following confirmation and tests tried out with tooltips for table/matrix, there is no tooltip bucket available today for a table visual. This means that all columns (including the needed date and time columns) are always passed through as context to the tooltip page, resulting in filtering that is not desired.

I find a number of PowerBI ideas about tooltip filtering for tables, where it would be beneficial that tooltip visualization and context filtering would become applicable based on selective column 'hovering' or in fact the tooltip bucket to become available, enabling the tooltip only on certain columns consequently.

Solution for this problem in particular - a date/time column influencing the tooltip filter context:

Apply a measure on the main table for each of the date/time columns that you show in the table. 

Start column -> FlowStart = SELECTEDVALUE(TableName[Start])

Add FlowStart as column to the main table.

Enable all filters as On for the tooltip page.

The date/time column does no longer influence the tooltip filtering.

---

Hi, 

We are creating a table visual on which we try to provide more contextual logging detail via a tooltip page. When on the table visual there is a date and time column specified the tooltip does no longer bring forward the necessary information. We however want to keep the date and time columns in the main overview:

The tooltip and filter is applied as following to ensure we only get the result back for the FlowId, but somehow the date/time column is still adding a context: 

Relation between view and this datasource have been set on the main FlowId column. 

I am looking how this date/time context can be influenced, disabled without losing the date/time formatting of this field in the main table visual.

[v-kpoloju-msft · Accepted solution]

Hi @FabricNJ,

Thank you for the follow-up question. Also, thanks for testing that so thoroughly and for pointing out the difference in behaviour between Keep all filters = On and Off. That’s very helpful.

What you are running into is a current limitation in Power BI: Table/Matrix visuals do not fully support the Tooltip fields bucket like charts do. This means that when keep all filters = Off, fields such as FlowId aren’t automatically passed into the tooltip unless they are part of the visual’s row context.

Workarounds you can try: Add FlowId (for Tooltip) (or the actual FlowId column) to your main Table visual. You can hide it by setting the font color = background color or shrinking the column width. This forces FlowId into the context, so your tooltip filters correctly.

If that is not feasible, you can leave Keep all filters = On (though it will also bring through other filters like Start date).
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips?tabs=powerbi-deskt...

For more advanced setups, you can create a dedicated tooltip measure that explicitly filters by FlowId.

Also, please refer this thread for quick understanding:
https://community.fabric.microsoft.com/t5/Desktop/Table-and-Matrix-Tooltips/m-p/502442 

It’s expected behaviour for Table/Matrix visuals. Please try the workaround and let us know if it gives you the filtering you need.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[v-kpoloju-msft]

Hi @FabricNJ,

Thank you for reaching out to the Microsoft fabric community forum and sharing the details and screenshots. Also, thanks to @Shahid12523, @GeraldGEmerick, for those inputs on this thread.

The behaviour you are seeing is expected when you hover on a row in the main table, the tooltip page inherits the full filter context from that row, including the date/time column. That’s why the tooltip gets “over-filtered” once a timestamp field is present.

If your goal is to show contextual log details only by FlowId (and ignore the date/time in the tooltip), here are some options please go through them.

Go to your tooltip page in the Format pane > Tooltip, turn Keep all filters = Off. Then add FlowId into the Tooltip fields well. This way, the tooltip will only filter by FlowId, and the date/time context from the main table won’t carry over.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

Please give this a try and let us know if it works, happy to help further if you have any doubts.

Thank you for using the Microsoft Fabric Community Forum.

[FabricNJ]

Hi, thanks for your response. Per suggestion, I have tried to keep all filters = Off and added FlowId into the tooltip fields (also on the tooltip itself). You can find that the tooltip does not seem to apply a filter in this case on the FlowId.

When I apply all filters = ON it works, however when a date/time column is added (as indicated in original post) it does no longer work. Does this seem like a bug?

[v-kpoloju-msft]

Hi @FabricNJ,

Thanks for the clear follow-up and for testing the first suggestion. It is not a Bug but expected behaviour. It is how report-page tooltips decide what filter context to inherit.

Pass only FlowId to the tooltip: Use this if you want the tooltip to ignore all other context (including the date/time) and show all log rows for that FlowId.

Tooltip page: Turn Tooltip ON (Page settings). In the Drill through / Tooltip fields area, add FlowId only. Set Keep all filters = Off.

Main table visual: Put FlowId into the Tooltips bucket of the main Table visual (you don’t have to display it in the table). Why: this makes FlowId part of the row’s context when you hover, so the tooltip can receive it even though it’s not shown as a column. Keep your Start (date/time) column in the table as normal.

Result: When you hover a row, the tooltip page receives only FlowId and ignores Start, so your logging table shows the full set of messages for that FlowId.

Tip: If your Table visual does not expose a Tooltips bucket, add a tiny measure like FlowId (for tooltip) = SELECTEDVALUE(Main[FlowId]) to the Tooltips bucket. Either way, the goal is to make FlowId part of the row context.

Please give this a try and let us know if it works, happy to help further if you have any doubts.

Thank you for using the Microsoft Fabric Community Forum.

[FabricNJ]

Hi,

Thanks for the suggestion and indication.

Since I don't have a tooltip bucket on the main visual, I looked into the possibility of adding a measure, which seems possible via power BI service on the model layout via the sql analytics endpoint.

I understood that the measure is to be added to the table which is used to represent the tooltip visual/page. I did this and added the measure field onto the visual as text (this displays as "(Blank)").

I now have the same result as before when showing the tooltip display from the Main visual, in this case also showing the additional blank field indication.

Let me know if I did anything wrong.

Regards,

Neal

[v-kpoloju-msft]

Hi @FabricNJ,

Thanks a lot for trying that out and sharing the details. I see where the confusion is happening. Let me clarify the right setup so that the tooltip page gets your FlowId context without being affected by the Start (date/time) column.

When you mentioned you do not see a Tooltips Bucket for the Table visual that is correct, some visuals (like Table/Matrix) do not expose it directly. The workaround is to create a small measure and add it to the Values area of the main table but styled so it does not clutter your display.

FlowId (for Tooltip) = SELECTEDVALUE(Main[FlowId])

Place this measure into your main Table visual (e.g., as a hidden column or with text turned white so it does not distract). On the Tooltip page, set Keep all filters = Off and in the Tooltip, fields add only FlowId. When you hover a row, the FlowId context will now be passed into the tooltip page correctly, while the Start column context will be ignored.

If the measure still shows (Blank) in your case, it usually means that the visual context doesn’t have a single FlowId per row. Please double-check that your main table has FlowId as part of the row context (e.g., coming from the same table or related dimension).

Please give this a try and let us know if it works, happy to help further if you have any doubts.

Thank you for using the Microsoft Fabric Community Forum.

[FabricNJ]

Hi, thanks for the indication, but I am not getting the desired result unfortunately.

I have added the measure as indicated to the main table/view. 

My tooltip is filtered only for FlowId

When I enable my main visual for tooltip, I select this tooltip page and the result is that I get the non-filtered tooltip logging as result

[v-kpoloju-msft]

Hi @FabricNJ,

Thanks for testing that and sharing back the results. If your tooltip is still not filtering by FlowId, here are a few checks and adjustments you can try.

Confirm FlowId is unique per row: The measure FlowId (for Tooltip) = SELECTEDVALUE(Main[FlowId]) will only return a value if there is exactly one FlowId in the current row context. If your main table is built from a related table (not directly containing FlowId), Power BI may not always resolve FlowId correctly. In that case, try using: 

FlowId (for Tooltip) = MAX(Main[FlowId])

Tooltip page setup: On your tooltip page, open Format pane > Page Information > Tooltip and confirm that keep all filters is on (so FlowId context is respected). Ensure only FlowId is driving the filter on the tooltip page. If start or other columns are still affecting it, remove them from the tooltip’s filter pane.

Add FlowId explicitly to the main visual: Even if you do not want FlowId visible, you must include the FlowId (for Tooltip) measure (or column) in your main table visual. You can hide it by formatting the column: set text colour = background colour or reduce column width to 1px. This way, FlowId is in the visual context, but not shown to end users.

Go to your tooltip page, drop a slicer for FlowId, and check if the Logging table filters correctly when you select a FlowId. If not, the relationship between your Logging table and Main table may not be set up correctly double-check the relationship in the model.

Refer this link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips?tabs=powerbi-deskt... 

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[FabricNJ]

Hi, 

Unfortunately, I am not getting to a result. 

The measure with MAX does not make the difference. 

I still believe there is a problem with the context being passed through to the tooltip.

When on the main visual there is no date and time column

AND tooltip page (keep all filters = on) the tooltip correctly displays the filtered list information, which to me means that the relationship and FlowID is being recognized as expected.

IF then on the tooltip page (keep all filters = off and FlowID is selected as field) the tooltip on the main visual shows an unfiltered list, which to me seems that the tooltip fields are not actually being used correctly. 

[v-kpoloju-msft · Accepted solution]

Hi @FabricNJ,

Thank you for the follow-up question. Also, thanks for testing that so thoroughly and for pointing out the difference in behaviour between Keep all filters = On and Off. That’s very helpful.

What you are running into is a current limitation in Power BI: Table/Matrix visuals do not fully support the Tooltip fields bucket like charts do. This means that when keep all filters = Off, fields such as FlowId aren’t automatically passed into the tooltip unless they are part of the visual’s row context.

Workarounds you can try: Add FlowId (for Tooltip) (or the actual FlowId column) to your main Table visual. You can hide it by setting the font color = background color or shrinking the column width. This forces FlowId into the context, so your tooltip filters correctly.

If that is not feasible, you can leave Keep all filters = On (though it will also bring through other filters like Start date).
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips?tabs=powerbi-deskt...

For more advanced setups, you can create a dedicated tooltip measure that explicitly filters by FlowId.

Also, please refer this thread for quick understanding:
https://community.fabric.microsoft.com/t5/Desktop/Table-and-Matrix-Tooltips/m-p/502442 

It’s expected behaviour for Table/Matrix visuals. Please try the workaround and let us know if it gives you the filtering you need.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[FabricNJ · Accepted solution]

Hello, 

Following some further analysis, I managed to identify the solution through applying a measure on the date/time columns itself and using the measure instead of the original date/time column in the main visuals. In this way the context of the date/time is not passed through to the tooltip and I do get the filter applied on the tooltip that I need.

Regards

[Shahid12523]

To stop the date/time column from affecting your tooltip while keeping it in the main table:
- ✅ Use REMOVEFILTERS('Logging'[Timestamp]) in your tooltip measure to ignore unwanted context.
- ✅ Or build the tooltip using a disconnected table filtered only by FlowId.
- ✅ Avoid placing Timestamp on the tooltip page visuals unless needed.

[FabricNJ]

Working with Power Bi service, so no possibility for a measure?

The relationship seems necessary to find the related records to FlowID in the tooltip datasource. If removed, all records are shown. 

Removing timestamp did not do the trick.

[GeraldGEmerick]

@FabricNJ Have you tried turning off "Keep all filters"?

[FabricNJ]

Yes, however this results in showing all records. Not only those for the same FlowId from the main table.