Forum Discussion

Alchemista's avatar
Alchemista
Frequent Visitor
7 years ago
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,...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    7 years ago

    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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Alchemista as mentioned before, powerbi is giving type any becuase of blank cells. You need to change the column type in Power Query, you can keep Blank as it is

Alchemista's avatar
Alchemista
Frequent Visitor
7 years ago

Ok, I changed the "type" of one of my $ columns to "fixed decimal number" with screenshot below. Now how can I format it to clean it up like adding $ signs, commas for 000 and removing decimals? Thanks,