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!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 13 | |
| 11 | |
| 9 | |
| 8 | |
| 7 |