Forum Discussion

kumsha1's avatar
kumsha1
Icon for Post Patron rankPost Patron
6 years ago

Graph with Bar and Line values on primary Y axis and Line values on Secondary Y axis

Hello Experts,

 

Is there a grpah in PBI where i can scale the data in Bars and lines on primary Y axis and line values on secondary Y axis?.

 

My requirement is to have...2 stacked bars and 1 line on primary Y axis and 2 **bleep** lines values on secondary Y axis.

 

Thanks

Need Help

5 Replies

  • lkalawski's avatar
    lkalawski
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    If I understood correctly, you would like to have 2 axis on Y. One for stacked bar chart and the other for line chart.

    You can get it by choosing one of two visualizations. Below I showed an example of a clusted barchart, however you can also choose stacked and set it the same way. You can add further measures to Column values and line values. It is important that you enable "show secondary axis" in Y axis panel.

    _______

    If I helped, please accept the solution and give kudos! ğŸ˜€

    • kumsha1's avatar
      kumsha1
      Icon for Post Patron rankPost Patron
      6 years ago

      I am trying to have 2 bars and 1 line (on primary Y axis) and 2 lines (on secondary Y axis) and i don't think it's possible with out of box PBI grpahs, i am currently trying custom visuals to see of there are such visualisations that can cater this requirement. Thanks for the follow up.

       

      Cheers

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi kumsha1 ,

         

        How about using Multiple Axes Chart - XViz? You can choose Series Type of each value column/measure.

              

         

         

        Best Regards,

        Icey

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.