How to get display value for Choices column when import data from Dataverse?

[erichuang]

I try to use Dataverse as the datasource of power BI. In the Dataverse Table a column [Result] is Choices columns which means users can select multiple items from the list. In power BI side after i import data from dataverse i only can get integer values, which are comma separated about the column. but Choice columns which  provide a drop-down list of items to a user to make a single selection can presented as two columns to show both the unique value, and the display item value,it works fine.

May i know how to get the display value for the Choices columns?

Thanks so much!

[Anonymous]

Hi @erichuang,

I think you need to create a dimension table with all the choice items and index, then you can look up values from this table to format integer values in your fact table.

If you are confused about the coding formula, please share some dummy data with a similar data structure to test.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng