topic Re: DAX SYNTAX IN POWER BI PAGINATED REPORTS in DAX Commands and Tips

DAX SYNTAX IN POWER BI PAGINATED REPORTS

Anonymous — Mon, 14 Mar 2022 17:39:24 GMT

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

Re: DAX SYNTAX IN POWER BI PAGINATED REPORTS

amitchandak — Tue, 15 Mar 2022 03:46:44 GMT

Anonymous , refer this, I think there isnothing function

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

Re: DAX SYNTAX IN POWER BI PAGINATED REPORTS

Anonymous — Thu, 17 Mar 2022 02:56:00 GMT

Hi Anonymous ,

Please update the expression of Textbox2 as below:

=Fields!ORD_ERR_ESO.Value Is Nothing

=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

Re: DAX SYNTAX IN POWER BI PAGINATED REPORTS

Anonymous — Fri, 25 Mar 2022 16:10:56 GMT

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