Forum Discussion

Jason-L's avatar
Jason-L
New Member
3 years ago
Solved

Table or Matrix - I cannot get them to work

HI All,

I have a table in Excel that is used for reporting. The table contains merged cells and text (No values). Im trying to replicate the table in PowerBI. I wanted to be able to freeze the first row so decided to use a matrix visual. The issue is i cannot get the visual to display all relevant data for the row as there is text and it keeps wanting to take 'First' Is there a way to sort this?

 

Thanks

Need Help
  • some_bih's avatar
    some_bih
    3 years ago

    Hi Jason-L create separate table for report form (with index or something like that unique and connect that "blank" report with your report and data. Hope this help.

1 Reply

  • some_bih's avatar
    some_bih
    Community Champion
    3 years ago

    Hi Jason-L create separate table for report form (with index or something like that unique and connect that "blank" report with your report and data. Hope this help.