Pay Band Graph

NickSirTek · ‎08-28-2024

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 · ‎08-29-2024

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 · ‎08-30-2024

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?