Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
In my Paginated Report I want to hide a row when a field is blank. This is what I've tried so far but
there is an error each time.
=Fields!ORD_ERR_ESO.Value = " "
=Fields!ORD_ERR_ESO.Valu = (" ")
=Fields!ORD_ERR_ESO.Value = [" "]
=Fields!ORD_ERR_ESO.Value = SPACE()
=Fields!ORD_ERR_ESO.Value = BLANK()
= IF( ISBLANK('ORD_ERR_ESO')
Solved! Go to Solution.
Hi @Anonymous ,
Please update the expression of Textbox2 as below:
=Fields!ORD_ERR_ESO.Value Is Nothing
or
=IsNothing(Fields!ORD_ERR_ESO.Value)
You can get more details about the expression examples in the following official documentation.
Expression examples in Power BI Report Builder
=IIF(IsNothing(Fields!LargePhoto.Value),True,False)=IIF(Fields!PhoneNumber.Value Is Nothing,"No Value",Fields!PhoneNumber.Value)
Best Regards
Thank You to all who responded to my question. I agree with the solution.
Hi @Anonymous ,
Please update the expression of Textbox2 as below:
=Fields!ORD_ERR_ESO.Value Is Nothing
or
=IsNothing(Fields!ORD_ERR_ESO.Value)
You can get more details about the expression examples in the following official documentation.
Expression examples in Power BI Report Builder
=IIF(IsNothing(Fields!LargePhoto.Value),True,False)=IIF(Fields!PhoneNumber.Value Is Nothing,"No Value",Fields!PhoneNumber.Value)
Best Regards
@Anonymous , refer this, I think there isnothing function
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 18 | |
| 11 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 26 | |
| 21 | |
| 13 | |
| 12 |