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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. 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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.