Forum Discussion
query editor & line chart
Anonymous this is what I will do, on table visual, add date column, add attribute column, and add attribute column again and change the aggregation to count and sort by this count aggregation column and you expect count 1 for each row and then we can debug it from there.
Anonymous it will sum entries for the same date and same attribute, can you make sure that 01/04/2014 for new orleans only one record, if you have more than one record that it will show the sum
Thank you for your reply,
There is only one on record, each date has 3 different attributes and 3 seperate values. So it should not sum them up.
I did it exactly the same as the first time I did it, see below, and it worked (With Year along x axis, amount along y and race as legend). I'm stumped
Anonymous this is what I will do, on table visual, add date column, add attribute column, and add attribute column again and change the aggregation to count and sort by this count aggregation column and you expect count 1 for each row and then we can debug it from there.
Hi
Thanks for your help, I will just mark the issue as solved and try and use less complicated data. I am new to power BI and its like you are speaking a completely different language. I cant do what you have asked of me because I dont know what you mean.
Thanks for your help its very much appreciated.
Anonymous hmmm not sure if you need mark it answer if your issue is resolved. I can walk thru the process if that helps.