Cross Report only working one way

Hi Anonymous ,

You can see the direction of relationship which is usually from one side of the relationship to the “many” side of it. the direction of a relationship means filtering. You can edit relationships and set direction to Both in your Many-to-One and One-to-Many models, then you will have two ways.

But you should not do this all the time. The both-directional relationship has a significant drawback about performance.

You can refer to this document: https://radacad.com/what-is-the-direction-of-relationship-in-power-bi

Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.