Forum Discussion
Need help: Scatter plot with Dates in X-axis
Hi all,
I want to create a scatter plot with date in the x-axis. My columns are below.
Order Date >> X-axis
Product >> Details
Product Category >> Legend
Profit % >> Y-axis
The scatter plot shows me an error "Remove Details to display x-and y-axis pairs. Altenatively, you can keep Details and set summariation for x-andy-axis".
I want to keep the Product as Details, as I want to show the markers for each Product. I do not know how to summarize the Date column.
Please can anyone help.
Fowmy - Here is the sample data and expected output. Appreciate your help !
https://1drv.ms/x/s!AtgHb7VNbJkrghTdQ0G8lTdw0K8d?e=Te7iGkThanks,Gautham
11 Replies
- Fowmy
Super User
Anonymous
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy - Here is the sample data and expected output. Appreciate your help !
https://1drv.ms/x/s!AtgHb7VNbJkrghTdQ0G8lTdw0K8d?e=Te7iGkThanks,Gautham
- mahoneypat
Microsoft Employee
This should be easy with the native scatter chart ... but it isn't. You need to use a custom visual. I made a quick one using Charticulator (see attached), but you can make a better one if needed.
(1) Can You Say "Charticulator"? - I Knew You Could - Portland Power BI UG - YouTube
Regards,
Pat
mahoneypat - Please can you share the same pbix file.
- mahoneypat
Here you go.
mahoneypat - Thank you looks great. If you don't mind, please can you share the custom visual you created as a .pbiviz file.
- mahoneypat
The shared link contains no files. Just an empty folder.
Regards,
Pat
mahoneypat- Please check now
- mahoneypat
Oops. Forgot to attach it. I will edit that reply to include it.
Regards,
Pat
- mahoneypat
Anonymous Did the visual work out for you? If so, please accept it as solution. Kudos also appreciated.
Regards,
Pat
v-jingzhangCommunity Support
Hi Anonymous
Has this problem been solved? If so, kindly Accept the appropriate reply as the solution or post your own solution to help close this topic. More people will benefit from it. Otherwise if you are still confused about it, please provide more details about your problem. Thanks a lot.
Best Regards,
Community Support Team _ Jing Zhang
