Forum Discussion
Unable to take count off
- 11 months ago
Hi alibarra , Thank you for reaching out to the Microsoft Fabric Community Forum.
Power BI tooltips always aggregate values, so seeing count of, sum or average on hover is normal, even if a column is set to Don't summarize. This happens because unless the filter context uniquely identifies a single record, Power BI must aggregate when multiple rows match.
To show raw, individual incoming and discharge pressure values on hover, create a dedicated tooltip page with a table or matrix visual including all relevant fields (date/time, pressures). Power BI will then display unaggregated raw data as long as the filter context filters to one or a few matching records.
Pie charts require aggregation and won’t reliably show raw data unless the filter context narrows exactly to one or two records. Setting a Pie chart’s Values field to Don't summarize only works if the filter context returns a single value; otherwise, aggregation happens. Using DAX to pick the first or last value is possible but generally not recommended.
Create report tooltip pages in Power BI - Power BI | Microsoft Learn
Work with aggregates (sum, average, and so on) in Power BI - Power BI | Microsoft Learn
Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn
alibarra Fields in tooltips need to be aggregated. You are using the preview feature on-object formatting so not sure how to guide you but if you didn't have that preview feature on, you could easily change the aggregation for the tooltip field from the Visualizations pane. Otherwise, perhaps you could use a custom tooltip page.