Forum Discussion
Unable to take count off
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
Community SupportHi 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