cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Qianru221 Regular Visitor
Regular Visitor

scatter plot with date on the x-axis

Hi all,

 

I plotted a graph of price versus date to show price changes across time using line chart. However I would like to only show the price as single dots i.e. to remove the lines connecting them. How would I be able to achieve that?

 

I have tried with scatter chart, but the date on the axis is counted. Therefore the result is now what I have expected. Anybody have an idea on how to present the price versus date in a scatter plot form?

 

Thank you.

 

1 ACCEPTED SOLUTION

Accepted Solutions
san_jois Regular Visitor
Regular Visitor

Re: scatter plot with date on the x-axis

Hi,

I tried using a dummy data..

Keep the Date hierarcy selected..

Under X-Axis, Concatenate-Off (toggle)

Hope it works

View solution in original post

6 REPLIES 6
san_jois Regular Visitor
Regular Visitor

Re: scatter plot with date on the x-axis

Hi,

Go to formatinng of the line chart

Under options, find X-Axis

Then Select the Type as Categorical

Scroll below to find Show marker and move the toggle to 'on' position

Increase the size of the bubble..you can choose the shape of the marker as well as the size and colour

Scroll up to see Data colours and choose the data colour as white..(Pls keep the background same as white, else select the data colour same as the background)

Thats it..

Hope it helps

 

 

Qianru221 Regular Visitor
Regular Visitor

Re: scatter plot with date on the x-axis

Hi

 

Many thanks for the help! It works.

However initially the x-axis is set as per month (since there are many price points per month and I averaged for each month, so for each month there is only one price point). After adjusting the x axis to categorical, every single price point shows up...so the x axis is extremely long now....

san_jois Regular Visitor
Regular Visitor

Re: scatter plot with date on the x-axis

Hi,

I am not sure if you have prepared a different sequential date table and connected your date from data with that. This helps because you can then use this date from sequential date table in all your plots.

 

Based on the level of drill down, the date table will have categories displayed on X axis

 

It would start with a year then move to Quarter-Month-Week and Day

 

Automatically, your data, which may be daily will get summed or averaged (based on the measure you choose during plotting)

 

On the other hand, if you have already connected, then just drilling up should solve your issue

 

 

 

 

Qianru221 Regular Visitor
Regular Visitor

Re: scatter plot with date on the x-axis

Hi,

 

My data contains several years of price information therefore when I drill down to month, it only displays from Jan to Dec. Would I desired is from e.g. 2014 Jan to 2018 Dec, every month there is an average price point of all the products sold during that month.

san_jois Regular Visitor
Regular Visitor

Re: scatter plot with date on the x-axis

Ok,

I think you can then try this..

Under Fields-Axis-Date--Select Date instead of Date Hierarchy

Rest of the settings remaining the same as per my earlier message

You can also have slicers of Year and month if you want to select for specific period

 

 

san_jois Regular Visitor
Regular Visitor

Re: scatter plot with date on the x-axis

Hi,

I tried using a dummy data..

Keep the Date hierarcy selected..

Under X-Axis, Concatenate-Off (toggle)

Hope it works

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 62 members 938 guests
Please welcome our newest community members: