Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
holywasabi
Frequent Visitor

Unable to use columns as Y-axis in scatterplot

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 : 

scatterplot-salary@4x.png

 

 

 

 

 

Link to .pbix file :

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

 

 

Many thanks in advance! 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Best you can do is use the min limit.

lbendlin_0-1730909921391.png

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.

 

 

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Best you can do is use the min limit.

lbendlin_0-1730909921391.png

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.

 

 

Thank you so so much! 😊 Learned something new today 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors