Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display percentage in graph

Hi everyone,

 

i am quite new to Power BI but already watched several training videos. Currently i am working on a Power BI report which will be embedded in SharePoint Online. One of the graphs shows Sales data (ytd) and planned sales for the year. My graph (s. below) shows only total values at the moment.

What i want to add is the percentage of actuals sales compared to the planned value -> (1600/9100)*100=17,58%   How can i do this?

Source Table Structure

 

Thanks

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can use the Line and stacked column chart visual to meet your requirement.

     

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    We can use the following measure and set it to the percentage format to meet your requirement:

     

    Measure = SUM(ActualTable[Sales])/SUMX(FILTER(ALL('ActualTable'),'ActualTable'[Period]="Plan"),[Sales])

     

     

     

    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thank you for your reply. Is it also possible to still display the total numbers and in addition somehow also display the percentage at the same time?

      • v-lid-msft's avatar
        v-lid-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        We can use the Line and stacked column chart visual to meet your requirement.

         

         


        BTW, pbix as attached.

         

        Best regards,

        Community Support Team _ Dong Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.