Row with no lookup value show as blank in matrix.

[Anpham2812]

Hi all,

I'm currently having a problem with this matrix in Power BI, each row that dont have a look up value are show as blank in below picture, so how can i name these at "Other Account"

https://i.imgur.com/A8cHQz4.png

Im unable to insert picture to this post, so please view it on imgur.

Thanks

[v-diye-msft · Accepted solution]

HI @Anpham2812 

It seems you have two tables with a relationship between them.  One table has rows that don't match in the other table so in your report it doesn't know how to label them so it labels them as (blank). The easiest way to stop this is to just set a filter on the report but beware this means you're filtering out data that probably is important.  The best approach is to figure out WHY there are blanks showing up - in other words, WHY are not all of the rows between the two tables matching.

This isn't 100% relevant but it may give you some insight https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-assume-referential-integrity/

[Mariusz]

Hi @Anpham2812 

You can add an extra line to your dimension with "Other Account" and populate that in the second table.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn