Forum Discussion
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...
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