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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
cmengel
Advocate II
Advocate II

Follow the (BLANK)

Follow The BLANK

 

As an upcoming coming Power BI Developer, one thing I wrestled with (besides mastering filter context) is the dreaded (BLANK) on a report page visual or a blank row in a table or matrix.  For those outside this field, this is an error response from the DAX engine.

 

In my early days, I was tempted to simply filter those results out.  It cleans things up, but it really only hides the error(s).

 

I've now grown to a point where I love the (BLANK).  Just today while running a data comparison inside a report I noticed some blank rows.   I followed the trail of the (BLANK) and it led me to an oversight in my data model.  A few minutes in Power Query and the problem was solved - no more (BLANK).

 

(BLANK) is a very powerful ally and can teach you many things if you are willing to swallow your pride, be coachable and dig in.

1 REPLY 1
v-yanjiang-msft
Community Support
Community Support

Hi @cmengel ,

 

Thank you for sharing, your insights have benefited me.

As the old saying goes, gold always shines.

 

Best Regards,
Community Support Team _ kalyj

 

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

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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