cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bwsutton1990 Regular Visitor
Regular Visitor

Cross Report only working one way

Hi

 

I seem to be having an issue where my Cross Report is only working in one direction. Is there any rules in relation to the relationship type between the "Table" and "Field" used for cross report puprosese? I have tried reading the documentation, but it doesnt seem to mention anything specifically about this.

 

Relationship Examples between models:

One :: Many - Drills from left to right

Many :: One - Drills from right to left

One :: One - Drills both ways

 

Any help on this would be greately recieved, as I would prefer not to re-engineer my data model Smiley Happy

 

Thanks

Ben

2 REPLIES 2
Community Support Team
Community Support Team

Re: Cross Report only working one way

Hi @bwsutton1990 ,

 

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.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bwsutton1990 Regular Visitor
Regular Visitor

Re: Cross Report only working one way

Hi

 

Although that is the case for setting up a data model for a singluar dashboard/report. I am looking to find out more about when drill through to a different dashboard within the same workspace.

 

At the moment I have dashboard A & B both with a table in their data model called "Examples1". I want to drill between them based on column "Name". Although I seem to be able to drill through from A to B, I cant drill from B to A.

 

This is what I am looking to understand and hopefully resolve.

 

Thanks

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 312 members 3,314 guests
Please welcome our newest community members: