Report Builder pie chart from Excel Forms Likert column

[mcollege]

Hi,

I've just discovered report builder and have a project to based on an Form for Excel but I'm having trouble visualising data from Likert data in report builder as a pie chart. The dataset is imported as a powerbi dataset from the excel online file that backs the form.

User	Measure1 Question1	Measure1 Question2	Measure1 Question3	Measure2 Question1	Measure2 Question2
User1	Very High	High	High	Medium	High
User2	High	Low	Medium	Medium	High
User1	High	Very High	Very High	Low	Medium

This works fine in PowerBI by dragging the multiple questions for a measure into the visualiser but I need to create the same pie chart in PowerBI report builder for paginated export to word.

Each slice in the pie needs to be the total of each response of multiple questions in each measure.

So User1 would have a pie chart for measure 1 ( Very High=3 , High=3 ) so a 50/50 Pie,  Measure2 ( Medium = 2, High=1, Low=1 ) 50/25/25 pie.

I can't seem to figure out how to acomplish this, the report is filtered with the user as a parameter. The chart generator in Report Builder seems geared towards numeric values instead of text based.

Do I need to do something like create new dataset with calculated fields or something like that?

Thanks

[mcollege]

Thanks,

I think I can work with that - I created another caculated field that adds the counts of each 'Very High' etc. together to get the totals for each measure and the graphs looks correct.

I just have to figure out renaming the text that appears in the legend

[grazitti_sapna]

Hi @mcollege 

You can try using this:- 

Create a calculated column 

Measure1_Question1_Count = IIF([Measure1 Question1] = "Very High", 1, 0)

Repeat this process for each measure and question combination, adjusting the conditions as per your Likert scale values.

Thank you. Hope this will help you.