Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JMelo
Frequent Visitor

Scatterplot over time

Hi,

on this example i have 3 producs with different prices each.

 

Could anyone give me a hint?

 

Lets say:

 

Jan

Product 1 - $100 

Produc 2 - $200

Produc 3 - $300

 

Feb

Product 1 - $50

Produc 2 - $55

Produc 3 - $60

 

I need to plot a scatterplot time over month, without summarize Producs. I want to see Product 1, 2, and 3 distribuited in that month

 

Example:

 

Capture.JPG

 

1 ACCEPTED SOLUTION

You don't need to do anything with it then, just drop the fields into the scatter plot...

 

scatter.PNG

View solution in original post

3 REPLIES 3
jthomson
Solution Sage
Solution Sage

Should be trivial to convert a data set in order to give you what you want, but without knowing what your data actually looks like it's hard to suggest how to do it

Month	Product	Price
Jan-19	Shirt	167
Jan-19	Jeans	229
Jan-19	Shorts	201
Feb-19	Shirt	105
Feb-19	Jeans	205
Feb-19	Shorts	196
Mar-19	Shirt	213
Mar-19	Jeans	209
Mar-19	Shorts	163
Apr-19	Shirt	236
Apr-19	Jeans	55
Apr-19	Shorts	200
May-19	Shirt	205
May-19	Jeans	120
May-19	Shorts	121
Jun-19	Shirt	250
Jun-19	Jeans	246
Jun-19	Shorts	72

Thanks,

this is the dataset, would it help?

You don't need to do anything with it then, just drop the fields into the scatter plot...

 

scatter.PNG

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors