Get Name for Dataverse choices column

[Anonymous]

Hello,

I am trying to make a report from my dataverse data.

I have connected to dataverse (import mode) but for choices column, I got Value on my data.

I would like to take Name instead.

 

I used Replace Value to solve this but Is there any way?

What do you think best practice(performance) for this problem?

[Anonymous]

@Anonymous 

But how do you want to display the columns names? Do you mean you want columns names in one columns?

Column

column1 name

column2 name

column3 name

Maybe try select the columns than unpivot.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Anonymous 

Thank you for your reply.

I tried but it shows like this.

I want to change like this.

[Anonymous]

Have you found a solution yet? I have been stuck on the same issue for days.