Forum Discussion

rfway's avatar
rfway
Helper I
10 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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?