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:
I have a couple of columns in a Power BI Report, both representing ERP's dimension codes (dimension values).
I want to add the description of the dimension values, but I only want it to display the description for one of these two codes (columns).
In the dimensions table, the "description" is the "Display Name".
How do I place an "if, then" statement in Power BI to "tell" the column to only display the description for the one code (column) that I have in mind?
Thanks!
jellis1971
Solved! Go to Solution.
Hey @jellis1971 ,
I didn't fully understand how you want to add the description. Can you explain that better?
If the description exists in a column and you only want to change the visibility, the following approach for a calculated column should work:
Display Name =
IF (
myTable[dimension code]
IN {
"Code 123",
"Code 456"
},
myTable[dimension discription]
)
Hey @jellis1971 ,
I didn't fully understand how you want to add the description. Can you explain that better?
If the description exists in a column and you only want to change the visibility, the following approach for a calculated column should work:
Display Name =
IF (
myTable[dimension code]
IN {
"Code 123",
"Code 456"
},
myTable[dimension discription]
)
Hi Denis:
It is kind of like what you said. The dimension code is "Facility", and I'd like for the dimension values for "Facility" to display instead of the ones for other dimension codes such as "Region".
jellis1971
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |