Forum Discussion
RobertSlattery
9 years agoResponsive Resident
Stop Summarising Data in visualisation
When I create a table visualisation from a query, a lot of stuff seems to be going on behind the scenes: its not just the table of results that is displayed but some summarised version of it. Rows se...
Phil_Seamark
9 years agoMicrosoft Employee
If you have a column in a table that only contains numbers, Power BI will assume you intend to sum the values in this column when grouping by something like date etc.
You can override this on the modelling tab but clicking your field and then choosing "Don't summarize" (or something else).
Does that help a little?
Elsabe7407
1 year agoNew Member
Hi Phil I don't have this "Default Summarization: Don't summarize" under my Modelling tab ... does anyone perhaps know why? Thanks!