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.
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.
So many thanks, I did. But I am getting something very strange. I have a query (view from sql) which returns all values, especially the field I am interested in which Is [CurrentSize]. I don't see this field in the fields list in spite of the fact that I can see it in the transform Tab table
whereas it is not available in the fileds list
In spite of the fact also, in another visual on the same page I did earlier, I can see the field in the values list but not in the fields list