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.
I am creating a training matrix in Power Bi. I have some trainings that get assigned to certain people but not others. If the box is blank, it means the person was not required to take the training. To avoid confusion, I would like to block out the blank boxes or use a DAX expression that will transform these values to something like "not required." I am not sure, however, how to manipulate the underlying data to achieve this. A screenshot of the matrix is below. Thank you in advance!
Solved! Go to Solution.
Hi @ld17 ,
If the field [(ENV) Environmental Training] is a fact field in the table, you create a calculated column as below to change the blank values. Otherwise, please provide the formula if it is a measure or calculated column. Thank you.
Column =
IF (
'Table'[(ENV) Environmental Training] = BLANK (),
"not required",
'Table'[(ENV) Environmental Training]
)
Best Regards
Hi @ld17 ,
If the field [(ENV) Environmental Training] is a fact field in the table, you create a calculated column as below to change the blank values. Otherwise, please provide the formula if it is a measure or calculated column. Thank you.
Column =
IF (
'Table'[(ENV) Environmental Training] = BLANK (),
"not required",
'Table'[(ENV) Environmental Training]
)
Best Regards
is (ENV) Environmental Training a measure?
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |