Forum Discussion
format multiple columns
Hi rfway,
Currently, we are not able to format multiple columns at the same time in data view of Power BI Desktop, regarding to this limitation , you can vote it and add comments in the following idea.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10312620-allow-selecting-multiple-columns-in-the-data-view
In addition, to work around this issue, you can consider to copy the data in Excel and format these columns at once, then re-load the data into Power BI Desktop. There is a similar blog about formatting multiple columns in Excel for your reference.
Thanks,
Lydia Zhang
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?
I'm having the exact same issue. I have dozens of columns that I want to change from whole numbers to %'s. They are formatted as % in Excel and in the query editor but not in my data view. Did you find a solution to this?