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
Hi alibarra , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.