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.
AlchemistaAs I mentioned in my post, you can change the format on column headers and if later you need to remove decimal, round up, or add more decimal places and 000, you can apply your query in PQ and do all these next changes in PBI report view. Please consider that in PBI you have three different environment. You should try to clean your data and formats first in Power Query then after applying to PBI(pushing your data to reporting view) you can then do these manipulations there.
If still not sure, please upload your excel file in Dropbox and leave the link here so that I can do the job as you desire...
Super Userparry2k 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.
