Forum Discussion

eliassal's avatar
eliassal
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper 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

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    5 years ago

    eliassal 

     

    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:

     

    • eliassal's avatar
      eliassal
      Icon for Helper II rankHelper II
      5 years ago

      OK, I did, the SUM sign disappeared but still on the graph data is not correct as in "Column Values " iis "Count of CurrentSize

      • eliassal's avatar
        eliassal
        Icon for Helper II rankHelper II
        5 years ago

        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?

  • eliassal's avatar
    eliassal
    Icon for Helper II rankHelper 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