Forum Discussion
Solved
How to import Excel data keeping the same column formatting? (%, $ and Unit Values showing properly)
Hello, New to Power BI, I have a question regarding how to successfully import data into Power BI with the same formatting as I see on Excel. In my data pull I have several facts like region,...
Alchemista your modelling tab will be disabled if data type in power query is text or any (abc/123). as soon as you changed the data type to number/whole number , you have format options.
AlchemistaWhy don't change the SPPD column to whole number or decimal number in PQ and then after pushing to your Report view change the format as desired there?
Anonymous I try to change format but do you know why my modeling/format tab is greyed out? How can I activate it? My table is selected as the screenshot below.
Alchemista change your data type to any number (i.e. Whole number, decimal number) it will work!