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?
Check out the custom visuals in the market.
Also, you could look at R visuals
Or Python visuals
Or perhaps the Charticulator
Proud to be a Datanaut!
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.
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