cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ckimball Frequent Visitor
Frequent Visitor

Show value with no data when filtering

Hello! I am a new Power BI user. I did some research on my question but was not able to find a solution.

 

I am trying to show a visualization (bar graph or matrix) that counts how many bugs are in each Sprint. For example, 2 bugs in Sprint 1, 3 bugs in Sprint 2, etc. See below for the column structure. I used basic filtering to filter out the "User Story" category. The issue is that Sprint 3 does not have any bugs, so it does not show up in my visualization, even when I select "Show items with no data." I would like it to show up in my visualization but am not sure how. Any suggestions? Not sure if I need to rearrange my columns, create a new measure, etc. 

 

SprintType
1User Story
1User Story
1Bug
1Bug
2User Story
2Bug
2Bug
2Bug
2User Story
3User Story
3User Story
3User Story
3User Story
3User Story

Sprint 3.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Show value with no data when filtering

@ckimball solution attached, I hope this is what you are looking for.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

5 REPLIES 5
Super User IV
Super User IV

Re: Show value with no data when filtering

@ckimball you can achieve with following steps:

 

create  new table for type using dax below

 

 

TypeTable = VALUES( YourTable[Type] )

 

 

Now create a measure for count using following DAX

 

Count Rows = 
CALCULATE(
Countrows( YourTable ), 
TREATAS( VALUES( TypeTable[Type] ), YourTable[Type] )
 )  

Now on graph, use type on x-axis and slicer from new typetable 

 

And it should work.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





ckimball Frequent Visitor
Frequent Visitor

Re: Show value with no data when filtering

Thanks @parry2k , I appreciate the help.

I created the suggested TypeTable and Count Rows measures, but was unable to get the desired result (still cannot see Sprint 3 in the bar graph). I want to keep the Sprint field on the x-axis, not the Type field (see image in original post). Let me know if the data I pulled into the Axis, Type, and Count Rows fields are incorrect.

 

 

Super User IV
Super User IV

Re: Show value with no data when filtering

@ckimball can you share sample data in excel






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Super User IV
Super User IV

Re: Show value with no data when filtering

@ckimball solution attached, I hope this is what you are looking for.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

ckimball Frequent Visitor
Frequent Visitor

Re: Show value with no data when filtering

Thanks, I was able to reach a solution.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors