Pay Band Graph

[NickSirTek]

Hello everyone,
Hoping someone can help me because I am at standstill.

I need to create a stacked bar chart (or whatever chart will work) to display blocks of the pay band ranges and then plot the employee names on the chart based on their salary.

here is what I have to work with:

1. I already was able to put the employee in 1 of 5 Paybands (PB1, PB2, etc..) in a column on one of my tables.

2. I need the bottom of the chart to show PB1, PB2, PB3 and the left side to show the salart ranges ($20000 to $200000). I have attached an image as an example.

3. The chart needs to show the blocks of ranges and then the plots (dots of each employee name based on the salary value)

I guess for the first part I need to confirm what chart on how to display the blocks.. I did this in Excel a while ago using Series() but that is not available in PowerBI

I have a table call PB Ranges which has the start, end and difference of the ranges.

I have a column with the employee and the pay band they fall in

I have a column with the salary for the employee which needs to be used to plot on the chart but it needs to display the employee name.

Any help is greatly appreciated, I feel defeated with this one lol

[ahadkarimi]

Hi @NickSirTek, give this a try, and if you encounter any issues, let me know.

Create Stacked Bar Chart:

X-axis-> Pay Band
Y-axis-> Range

Overlay Employee Data:

Use a Scatter Chart

X-axis-> Pay Band
Y-axis-> Employee Salary

Show data labels for employee names.

Adjust colors and labels for clarity.

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Supplier!

[NickSirTek]

This worked thank you, the only issue i have is with a slicer..since I did 2 different charts and overlayed them...the plot chart is showing the salary points in different spots as I slice by department. the department slicer works its just the plots are off...if I dont use the slicer all show correctly. I can provide screenshots but any idea?

[NickSirTek]

Anyone have any ideas or options where to start? need to get this done and I am at a standstill..appreciate any help. Thank you