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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ChannelDevMike
Regular Visitor

How do you get Count filter on data to show if the count is 0?

ChannelDevMike_0-1655303225578.png

There is one more type called "Client". Currently there is no missing "sharepoint folder" within any client so it is just not showing up. 

 
 

I thought this would work but it didnt show: (changing count to be more than -1)
(This is selecting just the 38 blanks)

tried.png

 

How would I achive getting 0 Clients to show up in my table? (I am new so it may be simple)

(This is selecting all folders, not just 38 blanks)

basic.png

3 REPLIES 3
Anonymous
Not applicable

Hi @ChannelDevMike ,

 

If you want to show Client type whose value is blank, I suggest you to turn on "Show items with no data" in [Type] column in Table Value Field.

RicoZhou_0-1655710691914.png

Result is as below.

RicoZhou_1-1655710755100.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hmm I really thought that would work... must be doing something else wrong here?

ChannelDevMike_1-1655730753289.png

@Anonymous 

 

Anonymous
Not applicable

Hi @ChannelDevMike ,

 

Your problem should be caused by your data model and I couldn't reproduce it in my side. Could you share a sample file without sensitive data with me? This will make it easier for me to solve your problem.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.