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.

themistoklis's avatar
themistoklis
Community Champion
5 years ago

Sorry i didnt explain it correctly.

 

Certain visuals require aggregated data in their 'values' section.

 

An example can be the graphs. You can have categorical data in X axis and a range of values in Y axis but in the values area you must have aggregated data. That's why the graph visual automatically applies an aggregation function. I hope it makes sense

eliassal's avatar
eliassal
Helper II
5 years ago

No not really, so how do I acheive what I want to do, is there any other visual that allows acheiving what I am looking for which is a very basic scenario if I am not mistaken?

  • eliassal's avatar
    eliassal
    Helper II
    5 years ago

    Hi, any idea?