Unable to use columns as Y-axis in scatterplot

holywasabi — Wed, 06 Nov 2024 11:54:24 GMT

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! ✨

Re: Unable to use columns as Y-axis in scatterplot

lbendlin — Wed, 06 Nov 2024 16:20:36 GMT

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.

Re: Unable to use columns as Y-axis in scatterplot

holywasabi — Thu, 07 Nov 2024 13:16:24 GMT

Thank you so so much! 😊 Learned something new today

topic Re: Unable to use columns as Y-axis in scatterplot in Custom Visuals Development Discussion

Unable to use columns as Y-axis in scatterplot

Re: Unable to use columns as Y-axis in scatterplot

Re: Unable to use columns as Y-axis in scatterplot