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.
Going crazy with a bridge (many to many) issue. I have two tables: task (task_id, task_name) and user (user_id, user_name). Since each task can be assigned to one or many users and each user can own multiple tasks, I need bridge task_user with primary keys from each user and task tables.
task table:
user table:
user_task table (bridge):
PBI relationships:
First, PBI table visual based on just user table:
Now, added task_name to the visual from task table:
The ask is this: I would like to display a list of users with a task name next to the user name. If no task is assigned to a user I would need empty string (user 3 record must be showing), if multiple tasks assigned to a user (e.g. user 1) just the the name of the first task should be shown. Something like this:
Possible? Appreciate any tips.
Thank you
Hi,
Change the relationships to single. In the user_task table, write this calculated column formula
Task name = related(task[task name])
From the User table, drag the 2 columns to the visual. Drag the Task name column from the user_task table.
Power BI DAX Function FIRSTNONBLANK Example - Power BI Docs
I don't know the answer but i think this function could help for the only showing 1 task per user
Thank you for input. I tried this option. Somehow many to many does not work well with FirstNonBlank
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |