Reply
Member
Posts: 64
Registered: ‎08-06-2015

Create scatter chart with date on x axis

Hello I have got simple test data set:

 

sample.PNG

 

 

 

 

 

 

 

 

 

 

 

 

I would like to create scatter chart I am used to do in R with plot (x,y).

 

I have got on problem

Chart is still aggregating values on x and y axis. I got over it by creating index column and using it in details.

But how to create chart when I want to use my Date column in x axis? (I do not want to create separate columns for day,month,quarter as it will show you only number in mousehover ).

 

My idea is to use directly date column to have 1-Jan, 2-Jan etc on x axis.

Is it possible? if yes, how?

 

Thanks

To have all

 

New Contributor
Posts: 544
Registered: ‎10-27-2015

Re: Create scatter chart with date on x axis

You can set the display format of your date in the 'Modeling' ribbon menu under Data Format, to determine how the date will be displayed in visuals.

 

If your concern is the default date hierarchy that is generated when adding a date to an axis, you can choose to display just the date. Some reading on this feature.

Regular Visitor
Posts: 31
Registered: ‎12-02-2015

Re: Create scatter chart with date on x axis

[ Edited ]

This sounds logical, but I'm running into the same problem. My date is formatted in the model and set to "Do not Summarize".

 

But on the X axis of the Scatter plot it shows as "Count of date". The only thing I can change is set it to distinct count. It does not show the date hierarchy either. 

 

Any ideas?

 

2016-02-16_13-21-01.png

 

 

 

 

Highlighted
New Contributor
Posts: 544
Registered: ‎10-27-2015

Re: Create scatter chart with date on x axis

For future searchers - another thread where this got covered: http://community.powerbi.com/t5/Desktop/Scatter-with-date-on-X-and-time-on-Y/m-p/19030