Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a "Persons" table and a "PersonVolunteers" table in Power Apps Dataverse. The Person Volunteer table has a lookup field for the Person. Power BI joins the two tables on Persons.PersonID and PersonVolunteers.Person with a 1 to 1 relationship. The PersonID field is their automatically generated ID. The Person field is a text field (from the lookup table.) When I use a table visualization, it lists all the Persons and all the Person Volunteers. I need only the Persons where the Person Volunteer matches. So there may be 100 Persons and only 5 volunteers. I need to only show 5 rows. How do I accomplish this in Power BI? This is a Model Driven App that generated the IDs and primary keys for me. I assume there is a PersonVolunteers.PersonID that it needs to join on the Persons.PersonID, but the PersonVolunteers.PersonID is not an option in Power BI.
Solved! Go to Solution.
Figured this out. I needed to change it from 1 to 1 to 1 to Many 🙂
Figured this out. I needed to change it from 1 to 1 to 1 to Many 🙂
User | Count |
---|---|
16 | |
10 | |
9 | |
9 | |
8 |
User | Count |
---|---|
23 | |
17 | |
12 | |
12 | |
12 |