Histogram Based on Rank

[redcotton9063]

Hi,

I have to create histogram(SS) based on data.Any idea how to get below chart.

Employee ID	Name	Rank Performance	Rank
122	Michael David	Underperformer	9
150	Lisa Douglas	Underperformer	9
125	Jennifer Smith	Inconsistent	8
130	Mohammad Rafi	Assess Fit to Role	7
131	Keith Loving	Effective	6
132	Riz Carl	Key Performer	5
133	Glen Rafael	Trusted / Key	4
134	Emily Painter	High Impact	3
135	Alex Mogno	Rising Star	2
136	Rookie Thomas	Emerging Leader	1
141	James Watt	Emerging Leader	1
155	Suzie Orman	Rising Star	2
165	Jim Ares	Effective	6
171	Jennah Magdoom	Key Performer	5

[Anonymous]

Hi @redcotton9063 

Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @redcotton9063 

I think you may need to build a R visual to achieve your goal.

The visual will look like as below.

You may refer to this blog: R Script - Overlay Normal Distribution Curve

For more info about how to build R visual in Power BI: Create Power BI visuals using R

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[CNENFRNL]

Hi, @redcotton9063 , you might want to use "Line and clustered column chart" viz in Power BI to visualize the data.

[amitchandak]

@redcotton9063 , Not very clear , see if these viusal can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380776?tab=Overview

https://blog.pragmaticworks.com/power-bi-custom-visuals-histogram

Or this blog

https://www.mssqltips.com/sqlservertip/4076/power-bi-histogram-example-using-dax/