Search code examples
matrixpowerbirow

Additional row with empty header in matrix in power bi


The problem is probably trivial but unfortunately I can't figure it out. Here are two basics tables: enter image description here

I tried to create the matrix based on the selected ID (from the Table2) with values from Table1. I created a measure "% Margin" (margin divided by revenue) and tried to add this to the matrix with ID from Table2. Every time besides ID from Table2 I got one additional row with empty ID. Anyone has an idea how to get rid it off? The rest of the matrix is correct.

enter image description here


Solution

  • Instead of using a separate static table, simply add a new column to you table and use that to filter your data for the report.

    Here's how this would look like:

    enter image description here