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.

Alchemista's avatar
Alchemista
Frequent Visitor
7 years ago

Anonymous thanks for the reply! I added some screenshots at the bottom of my original post if it will help you understand. As you can see from the screenshots, I already changed the percentage columns so it shows proper %. But how do I remove decimals, add commas for 000 for $ and units and how can I make Power BI import my excel files the way they are originally without the need for formatting the columns again in Power BI query?

 

Thanks,

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,