Table or Matrix - I cannot get them to work

[Jason-L]

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

[some_bih · Accepted solution]

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.