Help for Paginated report - Power bi report Builder

[tmshah61]

Hello all,

I have serval Tables in from same dataset. Different filters applied to tables. I have some tables has no values sometimes. report is running properly. When i am exporting no data table and next table is coming in same sheet in excel. i have tried to hide the tablix with 

IIF ( Countrows ( "Field") < 1 , TRUE , FALSE) 

but still result is same. 

I have kept different sheet name for the each tablix. 

Please tell me how i can extract each tablix on individual Sheets in excel .

Thank is advance.

[tmshah61 · Accepted solution]

=IIF(CountRows() < 1, True, False) in tablix visibilty working. now i am able to hide the Tablix. 

Thank you all for the help

[FFelix]

Hi, I have found a solution that works for me with this expression in the visibility of the Tablix: 

=IsNothing(Fields!XXXX.Value)

🙂

Thanks foir the help!

[FFelix]

Thank you, but this is exactly my problem: I am not able to find an expression that is able to tell me if there are no items in the Tablix that match a given parameter.  Any suggestion? Something like CountRows that satisfies the condition of the item being equal to the value of the selected parameter?

Thanks again

Felix

[R1k91]

something like this?

=First(Fields!OneFieldOfYourDataset.Value, "DataSet1") IS NOTHING

If filtering the dataset you get no rows the first is nothing

[FFelix]

Thanks very much, but it does not seem to work, as the 

First(Fields!OneFieldOfYourDataset.Value, "DataSet1")

return the first item of the Field which is not filtered by the parameter. Therefore the Tablix is empty put the First(xxx) is nothing is False.

Thanks again

Felix 

[R1k91]

have you already tried?

Exporting SSRS reports to multiple worksheets in Excel (sqlshack.com)

[FFelix]

I am quite a newcomer in the Power BI Reporting clan.

I have a similar problem, I wanted to hide a Tablix in case it contains no items as reslult of of paremeter selected in the reporting. Is there a way to have a formula to be used in the Visible property of the tablix?
Any help would be greately appreciated.

Thanks

Felix

[R1k91]

sure you can, just use the Expression builder in the Hidden property of that tablix. your expression must evaluated to true or false and can be built by parameters and/or datasets values.