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
mariaschmieder
Frequent Visitor

Blanks no longer being counted in visuals

Hello,

 

It seems like a setting in Power BI has changed and I can't figure out how to change it. In all of my power bi files, I have tried numerous different fields - and the same things happens. Whenever there are blanks, the blanks will not be counted.. but this did not used to be the case. See my images - you can see in the filter pane there are blanks, but it seems the blanks are automatically filtered out. Whereas before, I could see the count of the blanks by default. I have looked online everywhere to see if this is part of a recent update. I cannot seem to figure out what is going on.


So in this first image, it should be showing me the count of blanks, but instead it is showing there are no blanks - and i have the "count" function on....... thanks in advance!!

 

image (2).png

 

image 2.png

3 REPLIES 3
Anonymous
Not applicable

Hi @aduguid  ,

Thanks for the quick response.

Hi @mariaschmieder ,

Please have a try.

BlankCount = COUNTBLANK(Table[Column])

 COUNTBLANK function (DAX) - DAX | Microsoft Learn

 

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

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

 

 

 

 

aduguid
Super User
Super User

Have you tried creating a measure? 

Count of Milestone Status = COUNT([Milestone Status]) + 0

Hello, thanks! Yes I know there are workarounds and ways to get what i need. But I was more so just wondering if anyone knew if there was some setting in POwer BI? I was hoping to change a setting that I can include blanks being counted by default. In the past I know there was a setting in power bi where you could select "Show items with no data" .... but that is not a setting anymore... so wondering if anyone knew what could be going on?....

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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