Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

adding second header to table

Hi, I'm converting old financial reports to power bi. I have a table with a lot fo columns, so it has a horizontal scroll bar. The old report had labels for each column a through m: (numbers covered...
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi mkerfs,

    I think this is hard to achieve in Table(if you add new row in table, it will affect the column value’s calculation), so I suggest you use Matrix to achieve this goal. If your data sample like below

    Click query editor->Click last three columns->unpivot columns->close and apply, then add a column by expression like beow

    Column = SWITCH(Table3[Attribute],"ad", "columna", "at", "columnb", "ac", "columnc")

     

    Then you will get below result

     

     

    Best Regards,

    Zoe Zhi

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

dax's avatar
dax
Icon for Community Support rankCommunity Support
7 years ago

Hi mkerfs,

I think this is hard to achieve in Table(if you add new row in table, it will affect the column value’s calculation), so I suggest you use Matrix to achieve this goal. If your data sample like below

Click query editor->Click last three columns->unpivot columns->close and apply, then add a column by expression like beow

Column = SWITCH(Table3[Attribute],"ad", "columna", "at", "columnb", "ac", "columnc")

 

Then you will get below result

 

 

Best Regards,

Zoe Zhi

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.