Forum Discussion
Power BI Visual and slicer relationship error
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?
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
5 Replies
- Syk
Resident Rockstar
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.
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.
speedrampsSuper User
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
