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 User
parry2k thanks a lot! I managed to somehow fix the Tonn Vol column and set it as whole number, couldnt edit the left SPPD column though. And while trying, like I mentioned on my original post, I see the modeling tab greyed out. I dont know what caused it. How can I edit both columns separately? What makes the tab greyed out? Thanks,
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?
This worked! Thank you.
- parry2k
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!