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.
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!