Percentage of 4 values

[Anonymous]

Hi there,

So I'm very new to Power BI and I'm trying to create a report on the overall Customer Satisfaction of submitted surveys.

I have a table called "FAULTS" and the column for the Satisfaction Level is called "Satisfactionlevel".

1 = Excellent

2 = Good

3 = Okay

4 = Poor

I want to get a percentage of customer's scoring 1 and 2.

Apologies if that comes across confusing!

Any help would be greatly appreciated.

[Anonymous]

Hi @Anonymous ,

You can do it in two ways:

- Either you drag a count of that table to a visual (pie chart example) and in the categories you drag the satisfaction level.

- or you create a measure for each count dividing by the total

count Excellent will be = calculate(count(ID),Satisfaction Level="Excellent")

% Excellent = divide([count Excellent will be],count(ID),0)

Let me know if it helped, if so mark as solution.

BR,

DR

[Anonymous]

Hi @Anonymous 

Is there anyway of getting the pie chart to actually say "Excellent" instead of "1"?

Thanks, Chris

[Anonymous · Accepted solution]

Yeah,

You go to Data Labels and choose what you wanna show.

Like this:

BR,

DR