Power BI tutorial | How to decide the Cross Filter direction? | Single or Bi-directional

This video explains the importance of cross filter direction in Microsoft Power BI.
It discusses how the single or bi-directional filter affects the data in the report.

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[oindrilasanyal]

why is the relationship between Manager and Region is Many-to-one and not many-to-many when one region can have multiple managers and one manager can be assigned to multiple regions?

[DanielMensator]

HI, this does not seem to be right, if I look at your final " by Manager name report" (7:27) and sum up the values assigned to each manager it is almost 120mil and not 82

[Nanouk]

At 7:26, if you pause and look at the results, the numbers don't make sense. Revenue by manager name seems to be more than the real result. It has somehow allocated sales per manager. Can you please explain why this has happened?

[niroshdissanayake]

Can we remove the region table and link manager and sales tables by region name ?

[hiteshjoshi]

hey it really helped me thanks for uploading please make separate videos on relationships cardinaLITY AND CROSS FILTER THANKYOU SO MUCH

[priyanshusinha]

@LearnatKnowstar, why using a bridge table in between. When you have region name in sales table and Manager table too??

[vigneshsaravanan]

Yeah, I found the best example for cross filter direction 👌👌, Without talking too much, the girl jumped to the actual scenario 🤩

[debasishhazra]

so well explained on this important topic. Thank you so much for making this effective video ? Just a small info required, can we see how the SQL is geared at the background while creating report visualization ?

[sunilrawat-sexr]

but im show in Excel power query, its not showing that option in edit relationship...

[AlbrechtJ]

Rarely to find the instructor explain this important topic. Thanks for an excellent tutorial.

[ruvinisamanthika]

Its really worth for developers... Thank you

[vivekupadhyay]

instead we can connect manager table with sales table

[bxcks]

Good video.. if i may ask, does changing the filter direction to both cause problems? One instructor adviced to not use bidirectional

[shamalchavan]

by far the best explanation on this topic I have watched on this platform .

[ruthwickm]

Thank you so much! Very well-explained

[kristyowens]

One of the best explanations on this topic !