Forum Discussion
Creating a Scatter Plot by Month Year with quantitative data as individual data points
What I am trying to accomplish is recreate this Tableau Chart in Power Bi. It is a scatter plot using Year and Month as the X axis, and a measure on the y axis. I also have a legend associated to the individual data points.
I am having some difficulty recreating this cart. The reason being the Date. I can only seem to create the chart based on the Year, not Month Year.
When ever I try and add sort by Month, I get the following error message.
I created a column for Year Month, but that also did not work resulting in the same error.
I have read many articles and I am still not clear on how I can recreate this chart. I know I need to use some kind of DAX fuction, but I am not sure how to do this. If there is anyone that maybe able to help accomplish this I would greatly appreciate the help.
- Anonymous1 year ago
Hi Drisgoal ,
Please create a new calculated column and use it as the x-axis of the scatter chart.
YearMonth = FORMAT([Date], "YYYY-MM")Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- AnonymousNot applicable
Hi Drisgoal ,
Please create a new calculated column and use it as the x-axis of the scatter chart.
YearMonth = FORMAT([Date], "YYYY-MM")Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.