Forum Discussion
Dimension Description as a Column
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
Hey Anonymous ,
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] )If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
2 Replies
Hey Anonymous ,
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] )If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic