Forum Discussion

Drisgoal's avatar
Drisgoal
Frequent Visitor
1 year ago
Solved

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.