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.
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?
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
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?
Hi, any idea?
