Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Power BI Desktop, Model View - relationship's cross-filter direction is shown incorrectly

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:

 

mike_honey_0-1680055399883.png

However the Model View shows the reverse: Single (Table B filters Table A)

 

mike_honey_1-1680055453732.png

 



Status: Accepted

Hi @mike_honey 

I have submitted your issue to ICM . I will come back with updates if there is any progress .

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Accepted

Hi @mike_honey 

I have submitted your issue to ICM . I will come back with updates if there is any progress .

 

Best Regards,
Community Support Team _ Ailsa Tao