Forum Discussion
Why Power BIdoes agregate fields by itself
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.
OK, I did, the SUM sign disappeared but still on the graph data is not correct as in "Column Values " iis "Count of CurrentSize
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?
That's because 'Column Values' section in charts only accepts numeric data not categorical data.
So it automatically converts the categorical info to numeric .. by applying the count function
Also I cannot imagine how a graph can display categorical data in values area
No they are numeric, what do you mena by categorical data
Let me ask the question differently, you have seen the structure of the table, how can I plot a chart to show me size of each database by datein line chart or stacked, then filter by DB name? Can you share the steps to do this please?
Wich is the case if you look at the snapshot
