cancel
Showing results for
Did you mean:
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?

3 REPLIES 3
Highlighted
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

Proud to be a Datanaut!

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.

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