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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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