Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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!!
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.
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?....
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
87 | |
73 | |
55 | |
43 | |
38 |
User | Count |
---|---|
98 | |
63 | |
54 | |
48 | |
45 |