Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

query editor & line chart

Hello, I have absolutely no idea what is going on and have been tying to figure ot out all day, knowing me I am missing something simple. My data values does not go beyond 100 yet when I apply my d...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

okay...When you say add a column, do you mean in excel? Can you add a column in power bi?

Where is aggregation count?

 

Here is where I got my data from:

https://trends.google.com/trends/explore?date=all&q=New%20Orleans

I downloaded the csv from interest over time.

Maybe we should start from downloading the data if you have the time?

 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous are you open to share pbix file, remove any sensitive information before sharing, share through one drive/google drive or you can directly send it to me by email. My email address is in the signature.