Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RyanGilreath
Regular Visitor

Customer Voice - Matrix Question relating back to Parent question

Hello,

 

I've successfully linked my Customer Voice survey responses to PowerBI and have had a generally easy time of displaying simple "Ranking" style questions, as well as NPS and Choice.

The Matrix Choice questions however, have me stumped.

 

Where I am at right now is that there are two IDs in the "msfp_question" entity, 1 for the Parent Question and 1 for the Matrix options. What is the best way to relate these two so that I can display a table or matrix where the rows represent the individual respondents and the columns represent the Matrix question (parent and child). I have two of these in a survey and i'd like to use one visualization to represent them both.

 

Thanks in advance for any help!

2 REPLIES 2
nguyengiang2004
Frequent Visitor

You can use msfp_sourceparentquestionidentifier from MatrixChoice row (child) to link with msfp_sourcequestionidentifier from MatrixChoiceGroup (parent) to connect child with parent question. They are both from msfp_question entity.

LukeGoble
New Member

I'm having a similar issue. I have related the appropriate tables in Power BI, but for matrix type questions, the "Questiontext" values are null, making it impossible to pivot by question text.

LukeGoble_0-1677034449326.png

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.