Using a code description rather than codeID

[richrich123]

Hi everyone,

I wonder if someone could clarify for me please. I am using PowerBi to report on some Dynamics data. On a quote entity in dynamics, you have the status e.g Draft, Active, Closed etc.

In my quote entity table, the status is held as the code but in my BI Visuals, the code of course means nothing to end users viewing the data. Is there any way to resolve the code group to the description? Having a chart with headings of 0, 1, 2 etc is meaningless.

Thanks

[Greg_Deckler · Accepted solution]

So typically you create an Enter Data query to translate the codes to human readable values. I used to have a whole code translation thing for all of the status codes in Dynamics CRM.

[richrich123]

Super, thanks @Greg_Deckler  and @Vera_33 , that worked perfectly.

[Vera_33]

Hi, you can have a dim table to the screenshot you put, 2 columns, one is the code, the other is the Status. Create relationship with your dynamic table, and write DAX to display status instead of code. Or add a calculated column to display the Status, up to you.