Forum Discussion
erichuang
Microsoft Employee
Microsoft EmployeeHow to get display value for Choices column when import data from Dataverse?
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 i...
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