Forum Discussion
Why Power BIdoes agregate fields by itself
Hi, eliassal
In order to avoid the aggregation of related data, you need an index column.
Please create a new custom column based on clolumn "DatabaseName" and column "FileName".
ID = 'Table'[DatabaseName]&"_"&'Table'[FileName]Then apply it to the legend of Line Chart to replace your original field "DatabaseName".
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Also, as you can notice, I have DatabaseID, it is also sumed which really is disurbing me as well as the IDs column
You will notice next to the numeric field the letter 'Σ'
This means that when it will be summed automatically. To prevent this from happening, change the summarization from 'SUM' to 'Don't Summarize'. Image below:
OK, I did, the SUM sign disappeared but still on the graph data is not correct as in "Column Values " iis "Count of CurrentSize
Why for the sake of God Power BI forces us to use an agregate instead of the values of the fields, I don't really understand why so simple scenarion gets so complicated to acheive?
That's because 'Column Values' section in charts only accepts numeric data not categorical data.
So it automatically converts the categorical info to numeric .. by applying the count function
Also I cannot imagine how a graph can display categorical data in values area