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
9 Replies
miltenburgerHelper V
Don't know the exact tableheaders you have,
But has something to do with where orders = 'NULL'
- miltenburger
Can you show me the table in an image with records in it?