Forum Discussion
How to show values that do not match values from a different column?
Hi Anonymous，
As I tested, I create sample table as yours.
When I create a table visual to display the data, it still can shows the rows where OrderID is blank as follows. How can you get the second table you posted?
Please try to trun on the "Show items with no data" and check if it works fine.
Best Regards,
Angelia
v-huizhn-msft, that's the thing. I do not how to distinguish such kind of orders as there are no criteria
Say, you have two data sets:
Branch OrderID
A 1
B
C 3
D 4
Power BI will show it this way:
Branch OrderID
A 1
C 3
D 4
'How to find branch 'B'?' is the question.
Microsoft EmployeeHi Anonymous，
As I tested, I create sample table as yours.
When I create a table visual to display the data, it still can shows the rows where OrderID is blank as follows. How can you get the second table you posted?
Please try to trun on the "Show items with no data" and check if it works fine.
Best Regards,
Angelia
Thank you. That helped much.