Forum Discussion
Power BI keeps summarizing my data
Hello! I am fairly new to Power BI and I've been facing problems with the summarization of the data.
I have a massive dataset of numerical data and I have already specified the format and data type for each column, as well as chosen the 'Don't Summarize' option when I imported my data.
When I choose to display the data in table form, the data is shown correctly, but when I choose any other visualization my data is automatically summarized and the option 'Don't Summarize' does not show up in the Values tab.
I would appreciate any help or feedback!
3 Replies
ANaoum , All power visual other than Table Summarize values. Also in case of dutplicate values they will group for axis/row and legend.
In the case of table visual also it is distinct from all non summarized columns. This means they will not give the duplicate combination.
The work around is add index column in power query and use that in you visual as non/un summarized or axis /row/column
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
I have an index in my data. BI even tries to sum my index by default. I don't even have an option to "Don't Summarize".
Power BI needs to fix this ASAP. Having all visuals summarize data in incredibly frustrating. I just want to have visuals to view my data in different formats. 9/10 I don't want any sort of summarization. We can create columns/measures for that.
