Forum Discussion

eliassal's avatar
eliassal
Helper II
5 years ago
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...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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.

eliassal's avatar
eliassal
Helper II
5 years ago

Also, as you can notice, I have DatabaseID, it is also sumed which really is disurbing me as well as the IDs column

eliassal's avatar
eliassal
Helper II
5 years ago

I tried line and stacked column visual, it is also giving some bad graph. it also shoes the sum of all DB sizes for every date where I need to see columns by date by Database, here is a snapshot of the graph showing only SUM of all DBs sizes by date which is not really what I need to see. This is driving me crazy as to make a simple chart