Forum Discussion
eliassal
Helper II
Helper IIWhy 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.
eliassalHelper II
Helper IIOK, I did, the SUM sign disappeared but still on the graph data is not correct as in "Column Values " iis "Count of CurrentSize
eliassalHelper II
Helper IIWhy 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?