Creating a Scatter Plot by Month Year with quantitative data as individual data points

[Drisgoal]

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.

[Anonymous · Accepted solution]

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,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.