Forum Discussion
How to show values that do not match values from a different column?
I have two columns: branches and orders. Some of the orders correspond to certain branches. However, several branches do not have orders. How can I show the branches with no orders?
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
Microsoft Employee
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.