need help with direct query, visualization

Hi Anonymous ,

I can’t reproduce your issue. At least in theory, the way of left anti join should be worked. The following is my sample using two ways to implement. you can reference to modify your data. If you are still failed, please post some sample data and the expected output.

Question 1:

1. The first way is using left join in Power query.

These are my two tables.

Choose the column of order no in two tables.  Note :  the join kind should be changed according to your query1. If it is in the position of table1, then choose the left join. If not ,choose the right join.

1. The second way is managing a one-to-one relationship between two tables in report view. The visualization I used is a table.

Question 2 :

If you get data using direct query mode , in most cases, you need to install gateway. And there is a document you can reference.

Question 3:

Please post some data and screenshot about the issue of conditional formatting, then we can help you quickly.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.