Forum Discussion
Power BI Visual and slicer relationship error
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
Resident RockstarYou 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.
I see! Do you have a recommendation where I can create a relationship from job site to equipment rentals?
- 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.
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.