Forum Discussion

dave_mi's avatar
dave_mi
New Member
10 months ago
Solved

Merged cells acting as column header

Hi,

I am looking to build a power bi dash off an excel sheet, and when I import the sheet in the merged rows acting as a banner on the sheet are showing a colum header/titles

 

Excel sheet :-

In PBI :-

In Transform :-

Essentially Iam looking for what is in row 1 to be my actual Column header/titles.

 

Thanks

2 Replies

    • dave_mi's avatar
      dave_mi
      New Member

      The very definition of not being able to see it because I was looking at it 🙂

       

      Thanks, relatively new to Power Bi, good learning.