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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Competitor comparison using single visual

Hi,

I have to display an organization's rating for different aspects with compare to its copetitors on a single visual. If an organization has rating for manufacturing quality then users  should be able to compare the selected organization's quality rating to its competitors rating in the same visual not in the separate visual.

The below is the sample dataset and visual:

 

mypowerbi1_1-1639502709819.png

mypowerbi1_2-1639502749191.png

 

Please suggest how to compare selected organization's rating with its competitors in the single visual.

 

Thanks

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

 

You can try to client rating and peers rating into the same values in a single visual. And use the clustered bar chart.

vstephenmsft_1-1639723627053.png

 

 

Best Regards,

Stephen Tao

 

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

 

View solution in original post

3 REPLIES 3
radhey_rec
Resolver II
Resolver II

Hi @Anonymous ,

 

In case you want to combine the two 100% stacked charts, you can do that with PBI VizEdit service.  I am able to create following visual:

radhey_rec_0-1640183582451.png

with the data:

radhey_rec_1-1640183657388.png

 

Please note, these visuals do not support:

1. power bi native tooltips.

2. selection

 

Thanks,

-R

Anonymous
Not applicable

@Anonymous  Actually, I need to present it with the legend for 2 different values on 100% stacked bar chart. So, clustered bar chart doesn't qualify for this requirement. 

is there any visual which can present the data in this way? I came across to one custom visual "Multiple Axes chart" by xViz but it's subscription is paid not a free visual.

 

thanks

Anonymous
Not applicable

Hi @Anonymous ,

 

You can try to client rating and peers rating into the same values in a single visual. And use the clustered bar chart.

vstephenmsft_1-1639723627053.png

 

 

Best Regards,

Stephen Tao

 

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

 

Helpful resources

Announcements
Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.