Forum Discussion

dburdjal's avatar
dburdjal
Regular Visitor
7 years ago

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?

 

 

 

 

Need Help
Tips and Tricks

3 Replies

    • dburdjal's avatar
      dburdjal
      Regular Visitor
      7 years ago

      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. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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