Forum Discussion

tmshah61's avatar
tmshah61
Regular Visitor
3 years ago
Solved

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 tabl...
Need Help
  • tmshah61's avatar
    tmshah61
    3 years ago

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

     

    Thank you all for the help

FFelix's avatar
FFelix
Frequent Visitor
3 years ago

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's avatar
R1k91
Icon for Super User rankSuper User
3 years ago

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.