Forum Discussion
rfway
10 years agoHelper I
format multiple columns
is there a way to format multiple columns at once? This picture does not display the full data, but it basically contains dollar columns where I want to insert commas in each one-and ratios, w...
Anonymous
7 years agoNot applicable
I've been having this same issue and what I don't understand is, in my Excel source file I have my columns formatted as percentages, in the Power BI query editor, I have my columns formatted as percentages. However in the Power BI main tool, it's converted everything to decimal number format. I wouldn't have this issue if the program wasn't converting the data.
Why does it reformat in the first place from the original source file?
Anonymous
5 years agoNot applicable
Try this: https://community.powerbi.com/t5/Desktop/format-multiple-columns/m-p/894159/highlight/true#M428619