Forum Discussion
Helper IBox and Whisker
Hello Community.
I created a box a whisker chart to show the ranges for salary information by employee based on their job family name and wagetype (Hourly vs Salary). The chart will slice on hourly or salary with the job family name as the x-axis. I don't have measures, because I already have the min, max, median and 25th and 75th percentiles in columns. I'm not sure where I went wrong. Any help is much appreciated. Thank you.
| employee_id | job_family_name | job_code | salary_min | salary_25th_percentile | salary_median_50th_percentile | salary_75th_percentile | salary_max | actual_salary | wagetype_name |
| 2 | Advertising & Marketing | J0210 | $100,000.00 | $147,481.00 | $194,962.00 | $242,443.00 | $400,000.00 | $400,000.00 | Salary |
| 3 | Retail | J2228 | $16.00 | $16.50 | $17.00 | $17.50 | $18.00 | $18.00 | Hourly |
| 4 | Retail | J2228 | $16.00 | $16.50 | $17.00 | $17.50 | $18.00 | $18.00 | Hourly |
| 5 | Retail | J2262 | $8.25 | $8.75 | $9.25 | $9.75 | $10.25 | $10.00 | Hourly |
| 6 | Retail | J2236 | $11.56 | $12.06 | $12.56 | $13.06 | $13.56 | $14.00 | Hourly |
| 33 | Retail | J2077 | $22.50 | $24.19 | $25.88 | $27.56 | $29.25 | $28.00 | Hourly |
| 34 | Retail | J2126 | $13.83 | $14.29 | $14.76 | $15.23 | $15.70 | $16.00 | Hourly |
| 35 | Retail | J2031 | $70,307.00 | $83,565.50 | $96,824.00 | $110,082.50 | $123,341.00 | $112,777.00 | Salary |
| 36 | Retail | J2180 | $8.25 | $8.75 | $9.25 | $9.75 | $10.25 | $10.00 | Hourly |
Thankyou, GeraldGEmerick, grazitti_sapna and burakkaragoz for your responses.
Hi christinas,
We appreciate your question on the Microsoft Fabric Community Forum.
Based on my understanding of the issue, please find attached the screenshots and a sample PBIX file that may assist in resolving the matter:
We hope the information provided helps to resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.
9 Replies
- GeraldGEmerick
Memorable Member
christinas Which Box and Whisker visual are you using? Generally, most of the Box and Whisker charts that I have seen automatically calculate the percentiles, medians, etc. automatically from the base data.
christinasI created the chart using, "Line and stacked column chart". I tried the box and whisker by MAQ but it looked even worse than manually creating it.
- grazitti_sapna
Super User
Hi christinas ,
I'm assuming you are using Box and whisker chart by MAQ software.
Set up the fields like below-
Axis: Drag job_family_name here.
-
Axis Category 1: Drag wagetype_name here (this will let you slice/group by Hourly vs Salary).
-
Value: This is where it gets tricky. You usually need to drop your actual_salary here to generate the dots (outliers/distribution).
-
Dots: If you want to use your pre-calculated columns to override the automatic calculation, this specific visual generally still prefers calculating its own quartiles based on the value field.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
-
- burakkaragoz
Hi christinas ,
I agree with grazitti_sapna regarding the visual choice (MAQ Software is a standard go-to for this), but I want to highlight something about your data preparation that might be blocking you.
I see that you have done a lot of hard work pre-calculating the statistics (Min, Max, Median, 25th, 75th) in your source table.
Here is the good news: You usually do not need those pre-calculated columns!
Most Box & Whisker visuals in Power BI are designed to calculate these statistics dynamically from the raw data. They typically do not have specific "buckets" (field wells) where you can manually drop a "Q1" or "Median" value. Instead, they expect the raw distribution of data to generate the box itself.
How to configure it using your raw data:
Axis: Drop your job_family_name here (This creates a box for each job).
Axis Category: Drop wagetype_name here (To split Hourly vs Salary).
Value: Drop the actual_salary here.
Dots / Sampling / Details: This is the most critical step. Drop your employee_id here.
Why this works: By adding employee_id to the Details/Sampling bucket, you tell the visual: "Here is the list of all individual salaries. Please analyze the distribution and draw the Min, Max, and Quartiles for me."
If you try to map your pre-calculated columns, the visual won't know how to render the distribution because it is looking for the data points (employees), not the summary statistics.
Give the visual the raw actual_salary and let it do the math for you!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.- christinas
Hi burakkaragoz . Thanks for your reply. I am not using the MAQ box and whisker chart; it tried, but it calulated the ranges which is not needed. I am using, "Line and stacked column chart" becuase it lets me add the ranges. I have the min, 25th, median, 75th and max is because it is the market salary range's unique to the job code they are assigned to and shows where an employee's salary should fall between. I would like to be able to show the job family (IT, HR, Sales, etc) and drill down to the specific job code to see the ranges and where the average employees salaries fall within the range.
v-pnaroju-msftCommunity Support
Thankyou, GeraldGEmerick, grazitti_sapna and burakkaragoz for your responses.
Hi christinas,
We appreciate your question on the Microsoft Fabric Community Forum.
Based on my understanding of the issue, please find attached the screenshots and a sample PBIX file that may assist in resolving the matter:
We hope the information provided helps to resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.
- christinas
Thank you for your response. I was able to replicate this.
- v-pnaroju-msft
Hi christinas,
We would like to follow up and see whether the details we shared have resolved your problem. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.
Thank you. - v-pnaroju-msft
Hi christinas,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.
