Forum Discussion
Helper IReport Page Tool Tip displaying wrong data when hovering over 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.
Super User
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.