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

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

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

Thanks for all the help. I appreciate it. I guess I'm slightly shocked that this ability would not simply exist. Seems like it would be used often.

Brian

Well, the concept behind Power BI was to aggregate and visualize data, not just visualize data. That is why they included R visuals though as well as custom visuals capability to fill in some of these holes.

Hi bfaivre,

---

---

This is so much of what we do on a daily basis vs. showing the count of the data points (or another aggregate).

In order to show the count of the data points on a daily basis, you need to change Date Hierarchy to Date for Axis and use Sum for your Values. Then you should get the result you want.

If that is not the case, could you post some sample data and the expected result in your case?

Regards

I am trying to do the same thing. Time is on X , Value is on Y. Time is in the right format YYYY.MM.DD hh:mm:ss.

I can plot every value in the right order. Since I want to analyse the data for a month, I have like 50.000 Datapoint.

Now I want to aggregate or digg into the data. 

Just like it is already possible with Year, Quarter, Month and Day, I would like to extend that Hierachie to hour and minute.

Thanks for help!