Forum Discussion

Eva1's avatar
Eva1
Frequent Visitor
4 years ago

Setting a row as a %

Hi,   I have a table of data which i have brought into BI.  I would like one of these rows to be a %.  Is there a way of reformatting a row?  All i can see is how to reformat a column so im wonderi...
Need Help
  • Eva1's avatar
    Eva1
    Frequent Visitor
    4 years ago

    Hi

     

    Its really simple, so it would be 

     

    Revenue

    Cost of sales

    Gross Profit

    Gross Margin = Gross profit / Revenue as a %

     

    This last row is the one i need.  I have all the metrics over a number of years so can arrange it accordingly.  There is a youtube video https://exceleratorbi.com.au/build-a-pl-with-power-bi/

     

    However i find it quite complicated when it comes to writing the code.  Is there a simpler work round.

    • PhilipTreacy's avatar
      PhilipTreacy
      Super User
      4 years ago

      Hi Eva1 

       

      So you are after a P&L showing a percentage?  That's a different question to what you originally asked.

       

      I'm not sure I can explain it any better than Matt has done in his blog post and video.

       

      Without any source data it's even harder to code anything.  Please always supply sample data.

       

      Regards

       

      Phil

      • Eva1's avatar
        Eva1
        Frequent Visitor
        4 years ago

        Hi Phil

         

        So i have the calculation in my data file for the gross margin, so its there in power BI but it just remains as a decimal.  I thought to include revenue and profit as a column but where i get unstuck is adjusting my formula to pick these up