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 wonderi...
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
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