Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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
User | Count |
---|---|
18 | |
18 | |
14 | |
13 | |
13 |
User | Count |
---|---|
17 | |
14 | |
14 | |
10 | |
8 |