Power BI Visual and slicer relationship error

[GabGarcia]

Hello, 

I'm building a dashboard to track rental equipment usage within the company. To structure the data, I combined two queries to create a new "Job Assignment" table, which includes the unique job assignment IDs from both original tables. This setup allows me to establish a one-to-many relationship for better data organization.

I'm using a map visual with the job site address, but my slicers aren’t detecting the expected information. How can I ensure the relationships are properly connected?

[speedramps · Accepted solution]

You can learn about Power Bi relationships here

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

Your Job Assignment table has an One-To-Many relationships with Single cross filter direction.

 Therefore slicers on Equipment wont apply to Sites or vice versa.

Consider using Power Query to merge the Equipment and Sites to give you a single table.

This is not necessary the best practice but will give you very quick results if you are a Power Bi novice

https://learn.microsoft.com/en-us/power-query/merge-queries-overview

Or build a start schema with who, where, what, wher and when dimensions and fact table for measures.

Unfotunatley you have provided insufficient information for me to design a star schema for you.

However you can learn about start schema modelling here. 

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

Please click the thumbs up button for the ideas.

Also click [accept solution] if any work.

Thanks

[Syk]

You have relationships set up from 'Job Assignment' to both your other tables. The arrow on the line shows which way your data will filter. In this instance, 'Job Assignment' will filter both 'Job_Sites' and 'Equipment_Rentals'. However, 'Job_Sites' essentially has no idea 'Equipment_Rentals' is a thing and vice versa.

[GabGarcia]

I see! Do you have a recommendation where I can create a relationship from job site to equipment rentals? 

[Anonymous]

Your solution is so great speedramps 

Hi, @GabGarcia 

As Super User says, you need to follow the direction of the relationship filter. In the case of establishing a 1-to-many, we usually use the fields in the 1-end table to build some slicers to analyze our visual objects:

I think you can read the SQL BI article so that you can make the right decision:

Relationships in Power BI and Tabular models - SQLBI

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

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

[Syk]

I'd recommend exactly what @speedramps just posted. If you're new and unfamiliar with modeling and need quick results, make one huge table with all your data.