Forum Discussion

fabianotodao's avatar
fabianotodao
Regular Visitor
5 years ago

Select data linkage axis stack bar and line graphic

Hello guys, I would like some help with the following situation: I created a stacked bar and line graphic to show the Turnover per category, Year vs last Year, Actual vs Plan. When I put that infor...
Need Help
Tips and Tricks
Tutorial Requests
fabianotodao's avatar
fabianotodao
Regular Visitor
5 years ago

Hello v-xulin-mstf, thanks for the solution to share the example.

 

Dear all, below is the link to the Excel file that I made with some data example and 2 graphics, one with the expectation and the other simulating the Power BI output.

 

Link-to-file 

 

Could you help me to achieve the expected result?

 

Thanks for attention,

Fabiano.

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi fabianotodao,

     

    You can build algorithms to make total appear as a percentage of what you expect.

    I'm not clear the calculation logic of 'vs Plan' and 'vs LY'.

     

    Best Regards,
    Link

     

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

    • fabianotodao's avatar
      fabianotodao
      Regular Visitor
      5 years ago

      Hi v-xulin-mstf ,
      Explain the “vs Plan” and “vs LY”, they are respective:
      - Actual Turnover against Planed Turnover;
      - Actual Turnover against Same period Last Year Turnover.


      Unfortunately, my question still the same, how I can show a line with the total Turnover in $ that do not change the % axis that is linked if the variations against Plan and Last Year?


      In Excel the solution is simple, just link the Total Turnover line with the Primary axis and the other lines with the Secondary axis, but I don’t know how to do this in Power BI.


      Thanks in advance for your attention,
      Fabiano.

      • v-xulin-mstf's avatar
        v-xulin-mstf
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi fabianotodao

         

        Sorry, it is not supported.

        The three lines need to be the same unit.

         

        Best Regards,
        Link

         

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