Unable to use columns as Y-axis in scatterplot

[holywasabi]

Hi folks ~ appreciate any help with the following! ✨

I would like to create the following scatterplots :

Scatterplot 1
• x-axis : Temp Reason → [Termination Reason Sort] 'Term Reason'
• y-axis : Salary Range → [Salary sort] 'Salary Range'
• size of bubble : count of employee → [_measure] 'employees terminated total'

Scatterplot 2
• x-axis : Temp Reason → [Termination Reason Sort] 'Term Reason'
• y-axis : Salary Range → [Department] 'department'
• size of bubble : count of employee → [_measure] 'employees terminated total'

I am not able to use either [Salary sort] 'Salary Range'  or  [Department] 'department' as the y-axis.

Note 1 :

I have created a DAX measure to calculate / sort the number of terminated emoployees according to their salary range → [_measure] 'salary range measure (terminated)'

I tried using that for the y-axis and it does not work either. 

My desired result : 

Link to .pbix file :

https://drive.google.com/file/d/1wADE5MPFYkzLUyBkAD85yWZNac_OZGnY/view?usp=sharing

Many thanks in advance! ✨

[lbendlin · Accepted solution]

Best you can do is use the min limit.

Generally Scatter Plots are based on a coordinate system, and require numerical values for both x and y axes.  You are trying to use not one but two non-numerical values.   That can only be done with custom visuals.

[holywasabi]

Thank you so so much! 😊 Learned something new today