Forum Discussion
Report Page Tool Tip displaying wrong data when hovering over TOTAL line
So...I've just completed my custom built tooltip page that displays more information & charts about table data when the mouse is hovered above a row, and everything works wonderfully...Except today, when I was admiring my handywork I hovered on the TOTAL line of the table and noticed that the tooltip displays with data as if I were hovering over the top most line (RN1).
Is there a way to disable a Report Page Tool Tip from showing when hovering over the TOTAL line?
In Power BI, when you hover over the Total line, the tooltip often shows incorrect data because totals don’t have their own row context. Instead, Power BI reuses the first visible row’s context (like RN1), which causes that mismatch. Unfortunately, there’s no direct setting to disable tooltips only for totals, but you can fix it easily with a small DAX condition. Use ISINSCOPE() or HASONEVALUE() inside your tooltip measure so it returns blank when the hover is on the total. For example:
IF(ISINSCOPE(YourTable[RN]), [Tooltip Measure], BLANK()).
This makes the tooltip appear only for real rows, not totals. Alternatively, you can disable tooltips for that visual or create a dedicated tooltip page for detailed data only. In short, it’s expected behavior - Power BI treats totals as summaries without unique context, so managing visibility with a simple DAX check is the best and cleanest fix.
1 Reply
In Power BI, when you hover over the Total line, the tooltip often shows incorrect data because totals don’t have their own row context. Instead, Power BI reuses the first visible row’s context (like RN1), which causes that mismatch. Unfortunately, there’s no direct setting to disable tooltips only for totals, but you can fix it easily with a small DAX condition. Use ISINSCOPE() or HASONEVALUE() inside your tooltip measure so it returns blank when the hover is on the total. For example:
IF(ISINSCOPE(YourTable[RN]), [Tooltip Measure], BLANK()).
This makes the tooltip appear only for real rows, not totals. Alternatively, you can disable tooltips for that visual or create a dedicated tooltip page for detailed data only. In short, it’s expected behavior - Power BI treats totals as summaries without unique context, so managing visibility with a simple DAX check is the best and cleanest fix.