Forum Discussion
When Adding column from other table, it filters my rows
HI Anonymous,
AFAIK, power bi will auto hide the blank records in the visual. You can right click on the category field to choose 'show item with no data' option to force display these hidden records.
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Below link should give an example pbix where you see the exact same problem.
So tha AD table and WSUS table have a relation, but ad soon as I add the Updated Needed column a lot of row are filtered out of the table visual. Hope you see the problem.
HI Anonymous,
AFAIK, power bi will auto hide the blank records in the visual. You can right click on the category field to choose 'show item with no data' option to force display these hidden records.
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
This solves my problem indeed!
Thank you very much for the solution.
Be aware that when other controls will filter the one having "show item with no data", you will still see the others records.
