Adding a value in a chart which is not present.

[akash_mishra123]

Hi Everyone,

I am new in Power BI and got stuck in an Issue.

I have a data in which I will have to show count of no of occurence of particular choices.

Example - There are 50 persons who had to respond in a scale of 1 to 5, where 1 is Extremely Satisfied and 5 is not at all satisfied,

out of those 50 respondents 8 persons have selected 1(Extremely satisfied) , 10 persons have selected 2 , 26 persons have selected 3 , and 6 persons have selected scale 4, where as none of the persons have selected 5(Extremely Not Satisfied).

I want to Visualize a chart where I can show all the scale value irrespective of the fact whether the user has selected it or not.

basically my data is in the below format :-

Selected response                     Respondents Name

1(Extremely Satisfied)                Rock

1(Extremely Satisfied)                Mike

2                                                 Jorge

.                                                   .

.                                                   .

.                                                   .

.                                                   .

and there is a scale 5 which no respondent has selected but when I am taking the count of the selection , I am not able to show Zero for scale value 5 as it does not exists in the data, But as per requirement I need to show that as well,

I know this might be some silly question but I am not able to figure out any way to resolve this, Any help in this case will be much appreciated.

[Greg_Deckler]

Very difficult to provide specifics here. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But, in general you can solve these kinds of problems by creating your measure with an IF statement that if it is going to return BLANK, (ISBLANK) return 0 instead.

[akash_mishra123 · Accepted solution]

Thanks alot @Greg_Deckler for your help.

I got the way around and solved the issue. 

Regards,
Akash

[Greg_Deckler]

Awesome!