Forum Discussion
How to import Excel data keeping the same column formatting? (%, $ and Unit Values showing properly)
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.
Super UserAlchemista can you share screen shot? Do you have $ sign in excel file, does powerbi taking those columns as text as $ sign part of value and making it text instead of number. You have check all that in PowerbI
Hi parry2k, just added some screenshots to my original post! Also corrected $ to Units as for this example I was using units, but same logic as I try to remove decimals and add commas for 000.
parry2k wrote:Alchemistacan you share screen shot? Do you have $ sign in excel file, does powerbi taking those columns as text as $ sign part of value and making it text instead of number. You have check all that in PowerbI
- parry2k
Alchemista looks like it it is taking those column as type any may be there are some blank/empty cells in your data and that's why it is making it as type any. You can always change is in Power Query though.
- parry2k
Alchemista also check this link and hope it helps.
