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.
