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 ty...
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".