DAX SYNTAX IN POWER BI PAGINATED REPORTS

[Anonymous]

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')

[Anonymous]

Thank You to all who responded to my question.  I agree with the solution.

[v-yiruan-msft · Accepted 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

[amitchandak]

@Anonymous , refer this, I think there isnothing function

https://www.youtube.com/watch?v=w-LVgLexeEA