Forum Discussion
Solved
Why Power BIdoes agregate fields by itself
I have a sql table populated by a job everynight to monitore data and log file growth, here are some line of the table DatabaseID DatabaseName FileID FileName FileType CurrentSizeMB SpaceUsedMB P...
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.
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
Wich is the case if you look at the snapshot