Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
This is my case. I have my table with all my managers (40 managers), I want this table to be fix.
Then I have a second production table in where I just have 20 managers (that exist in the first table.
Problem: When I do the relationship, the first table match the second and give 20 filled rows
What I want is to see the others missing 20 managers that did not make production. I want it looks like the table below. So, I can know that Mary, Ryan and Louis did no make the production. I truly appreciate your help. Thank you so much.
Solved! Go to Solution.
in your visual, click on the arrow next to one of the fields and click "Show items with no data"
Hi @Anonymous ,
Check this link, it can help you:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
It shows only the correspondent values, if you have any missing you need to select this option to show non-match values.
in your visual, click on the arrow next to one of the fields and click "Show items with no data"
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |