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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
clairesjostrom
New Member

Visual for salary boxes

Hey all,

 

I'm wanting to visualize payroll data and I'm wondering if anyone has any good ideas about a visual that will help me show "salary boxes". I've looked at candlestick charts as well as box and whiskers but they don't quite fit the bill.

 

Ideally, I would like to populate the visual with these calculations or measures:

 

Lowest point of box = 10th percentile of Salary

Dot/marking in box = Median of Salary

Dot/marking in box = Average of Salary

Highest point of box = 90th percentile of Salary

 

Y axis = thousands

X axis = position and gender as categories

 

Any suggestions?

1 ACCEPTED SOLUTION
PijushRoy
Super User
Super User

Hi @clairesjostrom 

I am sharing two resources, can you please look into? You can download pbix file from here
https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery

https://community.fabric.microsoft.com/t5/Themes-Gallery/bd-p/ThemesGallery

 

If you have any specific design/wireframe in your mide, please draft it in PowerPoint and attach in ticket


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

View solution in original post

1 REPLY 1
PijushRoy
Super User
Super User

Hi @clairesjostrom 

I am sharing two resources, can you please look into? You can download pbix file from here
https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery

https://community.fabric.microsoft.com/t5/Themes-Gallery/bd-p/ThemesGallery

 

If you have any specific design/wireframe in your mide, please draft it in PowerPoint and attach in ticket


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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