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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Bokazoit
Responsive Resident
Responsive Resident

Survey with multiple answers and answers with amounts, how to deal with that?

I have a survey that I collect via API in a CSV format (I know it's old school, but that is how they deliver it). Each row consists of the answer from one respondent. Looks like this:

 

Bokazoit_0-1685528327375.png

and further in the columns:

Bokazoit_1-1685528357161.png

 

I know how to handle surveys with answers and multiple answers, but the number (amount) answers is a puzzle to me.

 

20 columns consists of amount answers like this:

 

s_19 header is "How many short conversations with patients?" = 3

s_2 header is "How many short conversations with Familymembers?" = 1

s_20 header is "How many short conversations with Both?" = 1

s_21 header is  "How many Long conversations with patients?" = 2

s_22 header is "How many Long conversations with Familymembers?" = 3

s_23 header is "How many Long conversations with Both?" = 1

s_3 header is "How many short conversations with Heartfailure patients?" = 1

s_4 header is "How many Long conversations with Heartfailure patients?" = 1

etc.

 

Each above is a columns as header and the number is the amount the respondent talked to.

 

One dimension (target group) of the survey is to show number of Short and long conversations. So I extract that from the data pivotatet as with any other survey (In the above it is s_19,s_2,s_20,s_4 that return short and the other returns long). Another dimension is with who (talk type) (Patient, familymembers, both etc.) - In the above s_19 and s_21 is patients.

 

Normally when I create a survey in PowerBI I get the data, pivot it and split out the dimensions to count the respondents. But now I also have amount, and one matrix / chart is (target group) and (talk type), but not with the count of respondents, but the amount of people they talked to.

 

Like this:

 

Bokazoit_2-1685529168993.png

 

How to do that?

 

I have several columns with numbers but if I think about lowest key value, lets say patient, family etc. I still have to divide between short and long conversations.

 

Does it make sense?

 

And how to handle this?

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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