Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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/
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/
Hi @Anpham2812
You can add an extra line to your dimension with "Other Account" and populate that in the second table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |