Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
in the the table below, there is a field corresponding to the Employee ID. In my report, I would like to display the employee name instead of the ID. My options are:
However, I'd like to learn whether that is something I can achieve dinamically, through a measure too.
Thank you.
Solved! Go to Solution.
I guess you have an employee table with unique values, right?...if that is the escenario, make a relationship between the employee table (or whereever you have the employee names as unique) and the table you only have employee ID... after that you will be able to use the name column from that table everywhere in your model.
I guess you have an employee table with unique values, right?...if that is the escenario, make a relationship between the employee table (or whereever you have the employee names as unique) and the table you only have employee ID... after that you will be able to use the name column from that table everywhere in your model.
@Anonymous thank you, appreciated.
I did not have that table but I do now. So simple, I just created. The solution will also serve for other similar situations.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |