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)
-
v-jtian-msft
on:
Error: Tied rows detected in the relation paramete...
-
v-jtian-msft
on:
Power BI Gateway SQL Server Connection Issue
-
v-jtian-msft
on:
Power BI integration on MS List. Where is the Powe...
-
v-jtian-msft
on:
PowerBi desktop modal dialogs in background, GUI u...
-
v-jtian-msft
on:
User defined fields in Outlook are not displaying ...
-
v-jtian-msft
on:
Duplicate measure name when adding measure to live...
-
v-jtian-msft
on:
Issue in Loading the Schedule Refresh
-
v-jtian-msft
on:
Dynamic format Strings and showing multiples of 10
-
v-xiaoyan-msft
on:
Issue with New Snowflake Connector in Power BI Des...
-
v-xiaoyan-msft
on:
BUG: DAX Variable is storing the filter conditions...