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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
akash_mishra123
Regular Visitor

Adding a value in a chart which is not present.

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.

 

 

 

1 ACCEPTED SOLUTION

Thanks alot @Greg_Deckler for your help.

 

I got the way around and solved the issue. 

 

Regards,
Akash

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

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.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Thanks alot @Greg_Deckler for your help.

 

I got the way around and solved the issue. 

 

Regards,
Akash

Awesome!


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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