Unable to take count off

[alibarra]

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" value when I put it together, see below.:

I want the pie chart to show the exact reading of incoming pressure on one half and discharge pressure on the opposite side that I have when I hover over points in my main page:

I've gone ahead and made the each of the pressure sections in the query editor as "whole" number":

I've also gone into the column tooks to indicate:

but the information STILL shows as "count of" 

....I've been unable to identify the root cause and don't know where to go from there.

[v-hashadapu · Accepted solution]

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]

Hi there, I'm not looking for the average data but rather the raw data of the specific day and time so when I hover a specific date in the scatterchart the piechart will show that raw data for the incoming and discharge pressure

[v-hashadapu]

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.

[alibarra]

@GeraldGEmerick GeraldGEmerick  , It's still not working for me...not sure what I did wrong:

https://drive.google.com/file/d/1fAKLOnu0ovOSh853hchcGkWd20uWF6nA/view?usp=sharing

The goal is to have each data point on the scatter plot that outlines the total difference between incoming and discharge pressure show (and when hovering the tooltip pie chart showing the exact raw data for the discharge and incoming pressure for that day/time). 

There are days that have several data points taken, but I'm also not sure how to show each bullet point on the scatterplot from the formdata data in the powerbi query. 

[GeraldGEmerick]

@alibarra Hoping this clears things up:

[GeraldGEmerick]

@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.