Forum Discussion

alibarra's avatar
alibarra
Regular Visitor
11 months ago
Solved

Unable to take count off

I have been attempting to create a tooltip that will show the exact data (not sum, not average and anot count) when I hover over a point on my main page-unfortunately I keep getting the "count of" va...
  • v-hashadapu's avatar
    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