Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!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.
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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
15 | |
15 | |
13 | |
11 | |
10 |
User | Count |
---|---|
11 | |
10 | |
6 | |
6 | |
6 |