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 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 Anonymous Thanks for all the replies. One more question. Is there a way to bring in Nested type of data like seen on my excel screnshot below? Or does Power BI only handle 1 title row at a time? Like do I need to separate all these columns on their own tabs and then bring or is there a way to bring all this nested data and Power BI automatically picks up by timeline and region? Thanks,
- parry2k
Alchemista 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,