I just finished the Lab 2 Exercise 1, and realized that the answer of 2nd question (what is the cross filter direction of the relationship?) shall be "Single" not "Both". The provided answer was wrong.
Referring to the "Creating calculated columns" Video in "Data Modelling in Power BI Desktop" section, the result was also "single".
Could anyone let me know your answer to this question? Thanks
In the first list, Steps 3 - 5 specify ensuring that the first three relationships have Both cross directional filtering. However, in the second list, Step 6 reads only "Link the newly created CountryZip column on the Sales table to the newly created CountryZip column on the Locations table." Nowhere in the instructions does it specify changing the default filtering direction, which is Single.
I followed the steps as well and by default I got SINGLE as the cross filter direction.
Can you let me know where I went wrong?
Also wile creating a relationship from Date column in Sales table to Date column in Date table the default cross direction filter obtained was SINGLE. I changed it manually to BOTH as instructed in the lab.
Hi I followed the same steps and also got SINGLE as the default Cross direction filter.
Please let me know where I went wrong.
Also after creating many to one relationship between Sales[Date] and Date[Date] I got SINGLE as the default Cross direction filter,
I then changed it to BOTH as per the instructions.
I've just had the same issue. After creating the relationship the Cross Filter Direction was "Single", I had to manually change this to "Both".
If you follow the directions on the lab instructions you end up with the incorrect answer.
Find out how to participate in the first Power BI 'Can You Solve These?' challenge.
Exciting news: We've given our badges an overhaul and added brand news ones.
Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.
Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.