Forum Discussion

rajiv_tarafdar's avatar
8 years ago

Change all Data Formats

Hi Guys, 

 

Is there a way to change / specify data formats for specific data types in Power BI Desktop for all columns once, so I dont have to change each column data format one at a time. Its quite time consuming now doing one at a time. Is there a smarter way to do this? 

E.g. I want all date columns to have date format dd/mm/yyyy or all Decimal Columns to have format ######.##

 

 

 

Thanks

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    To the best of my knowledge, no as Desktop does not allow you to select multiple columns and then choose a Format.