Forum Discussion

Regular Visitor

9 years ago

Plot Values (y axis) vs. Time (x axis)

Hello, I’m sure I’m missing something really basic here. But I have data that I retrieve from a database. The first columns represent timestamps and the second columns represents values. I simply...

Community Champion

9 years ago

OK, just change it to SUM or AVERAGE then, or maybe MAX.

Regular Visitor

9 years ago

Thanks for the response. That just give me another aggregate. I simply want to plot each value on the y-axis based on the timestamp on the x-axis w/no aggregation.

Brian

Greg_Deckler
Community Champion
9 years ago
I think I posted a way to do this using R visualization and ggplot, let me see if I can find it. Well, couldn't find that one, but it is an option, you also can see this solution as well:

http://community.powerbi.com/t5/Desktop/Scatter-plot-summarizing-data/m-p/37229/highlight/true#M13652
- bfaivre
  Regular Visitor
  9 years ago
  Thanks for all the input. This still isn't working for me. Surely it can't be that difficult to plot values on the y-axis over time on the x-axis? This is so much of what we do on a daily basis vs. showing the count of the data points (or another aggregate).
  
  Does anyone have an viable example or tutorial they can share?
  
  Thanks in advance,
  
  Brian
  - Greg_Deckler
    Community Champion
    9 years ago
    Power BI was really built around the concept of aggregating information. You can get around this by using R visuals, I found my other thread:
    
    http://community.powerbi.com/t5/Desktop/Line-Chart-as-quot-Excel-Scatter-Plot-quot/td-p/75954