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 there is many way to achieve these. All this can be different measures, lot of it going to be in modelling.
Logic is to bring as raw data as you can, and develop measures using DAX to meet requirements.
parry2k Anonymous As I try to clean up my data in Excel before bringing to Power BI, I wanted to ask how to repeat the cells you see in the screenshot below. My data comes with a title region/banner name and all data under it. But the region/banner column comes all merged per region and I unmerge it. However for Power BI to pick up each product line with banner information, I want to repeat these cells for each. In example below I fill the Circ K, then Shell etc the list goes on under. What is the efficient and quick way to do this?
Thank you,