Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

Dealing with Ranking and Choice Questions/Answers in Power BI

Posted on by 5

I'm looking to visualize data in Power BI based on survey's made in Customer Voice. Going through the process, I'm having trouble extracting and figuring out how to get the actual rankings selected. Right now, when pulling from CDS, it just gives me all 4 answers after extracting it from it's JSON format in one cell. There is no data about which was ranked first other than the order listed. How do I get the rankings selected so that I can visualize them? See below as an example of what I'd be seeing in the response column:

pastedimage1648759774968v1.png

  • NielsSL Profile Picture
    NielsSL 87 on at
    RE: Dealing with Ranking and Choice Questions/Answers in Power BI

    CT13 did you find a solution to this? 

    It seems this requires a certain amount of data transformation to make the data useful in Power BI. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans