Forum Discussion
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 wondering whether to change the entire format of my file.
5 Replies
Hi Eva1 ,
Just as what PhilipTreacy mentioned, formatting is by columns in Power BI.
Could you show more details or create a smaple for me and let's check if there are any workaround for your scenario?
Reference:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Icey
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.
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
