cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dburdjal Frequent Visitor
Frequent Visitor

Double-Axis Horizontal Stacked Bar - Scatter Combo Chart?

Hello,

 

I'm trying to create a double-axis bar chart like this Salesforce one in PowerBI - but there is no double-axis horizontal stacked bar chart option. Any suggestions?

 

 

 

 

image.png

3 REPLIES 3
Highlighted
Super User
Super User

Re: Double-Axis Horizontal Stacked Bar - Scatter Combo Chart?

Check out the custom visuals in the market.

 

Also, you could look at R visuals

https://community.powerbi.com/t5/R-Script-Showcase/bd-p/RVisuals

 

Or Python visuals

 

Or perhaps the Charticulator

https://charticulator.com/docs/video-tutorials.html


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

dburdjal Frequent Visitor
Frequent Visitor

Re: Double-Axis Horizontal Stacked Bar - Scatter Combo Chart?

Thanks Greg, but that did not really answer my question. Unfortunately I don't know how to use R. There are no such visuals in the marketplace either. 

 

Is there a way to just add the counts as a data label? I can't seem to figure that out either. 

GauravSingh Regular Visitor
Regular Visitor

Re: Double-Axis Horizontal Stacked Bar - Scatter Combo Chart?

Well,

 

just learn  ggplot and some simple function in R.

 

here is the example of code related to you problem :

 

ggplot(Chart)  + 
    geom_bar(aes(x=Year, y=Response),stat="identity", fill="tan1", colour="sienna3")+
    geom_line(aes(x=Year, y=Rate*max(Chart$Response)),stat="identity")+
    geom_text(aes(label=Rate, x=Year, y=Rate*max(Chart$Response)), colour="black")+
    geom_text(aes(label=Response, x=Year, y=0.95*Response), colour="black")+
    scale_y_continuous(sec.axis = sec_axis(~./max(Chart$Response)))

just try to understand 6 function used in the above code and  syntax

 

Hope this will help

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 491 members 4,283 guests
Please welcome our newest community members: