March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I've noticed that the Model View in Power BI Desktop displays the Cross filter direction incorrectly sometimes. A consistent repro scenario is when the Cardinality = Many to many, and the Cross filter direction is set to one of the "Single .." choices. The Model View always seems to show the tables reversed when the relationship is selected with a single click. If you double-click to open the Edit relationship pop-up, the correct order of the tables is shown.
I've built a simple repro file to demonstrate this - here's the link:
cross filter direction model view 2022-03-29.pbix
The correct Cross filter direction is: Single (Table A filters Table B), as shown in the Edit relationship pop-up:
However the Model View shows the reverse: Single (Table B filters Table A)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.