Hi @John_Doe3
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thank you @OktayPamuk80 for responding on this topic.
Power BI is built on a semantic data model, designed for analyzing large datasets unlike Excel, which directly plots individual rows. As a result, numeric fields are automatically aggregated (e.g., sum, count) when added to visuals.
Even if a field is set to “Don’t summarize,” Power BI may still aggregate it based on how the visual is structured. Specifically, if the Axis field contains repeating values (such as Date or Category), Power BI will group by that field and aggregate the corresponding numeric values. It's also important to note that changing a field’s default summarization only applies to newly created visuals, not existing ones.
To avoid unwanted aggregation, use a Table visual to verify raw data, ensure your Axis field uniquely identifies each row (like a timestamp or ID), and if needed, use a DAX measure like
ShowRawValue = SELECTEDVALUE('Table'[Column_Name]) to force display of individual values only when exactly one exists in the current context.
This approach gives more control over how data is visualized and ensures the results match your expectations.
If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.
Thank You!
