Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
tmshah61
Regular Visitor

Help for Paginated report - Power bi report Builder

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.

 

1 ACCEPTED SOLUTION
tmshah61
Regular Visitor

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

 

Thank you all for the help

View solution in original post

8 REPLIES 8
tmshah61
Regular Visitor

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

 

Thank you all for the help

FFelix
Frequent Visitor

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
Frequent Visitor

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
Solution Supplier
Solution Supplier

something like this?

 

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

 

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


--
Riccardo Perico
BI & Power BI Engineer @ Lucient Italia

Blog | GitHub

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FFelix
Frequent Visitor

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
Solution Supplier
Solution Supplier

have you already tried?

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


--
Riccardo Perico
BI & Power BI Engineer @ Lucient Italia

Blog | GitHub

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FFelix
Frequent Visitor

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
Solution Supplier
Solution Supplier

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.


--
Riccardo Perico
BI & Power BI Engineer @ Lucient Italia

Blog | GitHub

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.