Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
36 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |