Forum Discussion

kram1234's avatar
kram1234
New Member
3 years ago
Solved

Indentation table template from Excel not loading

Hi,   I try to add a Excel-template with a hiërarchie for a "Cost-overview". But when I try to load the template in Power BI, the indentation is gone (I know about switching off "Word Wrap").   I...
Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    Hi kram1234,

     

    I can't load your files, but I guess the identation is not space-generated, this is rather formatting in Excel?

    I just had to sort the same issue. The problem is that PBI does not care about cells meta-data (including formatting) and only take the actual value of the cell.

     

    I worked around it with a macro that would analise the identation and create a separate column to record the identation level, which then can be used in PBI.

     

    Kind regards,

    John 

jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Hi kram1234,

 

I can't load your files, but I guess the identation is not space-generated, this is rather formatting in Excel?

I just had to sort the same issue. The problem is that PBI does not care about cells meta-data (including formatting) and only take the actual value of the cell.

 

I worked around it with a macro that would analise the identation and create a separate column to record the identation level, which then can be used in PBI.

 

Kind regards,

John