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 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.

 

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

8 Replies

  • FFelix's avatar
    FFelix
    Frequent Visitor
    3 years ago

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

  • FFelix's avatar
    FFelix
    Frequent Visitor
    3 years ago

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

      something like this?

       

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

       

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

      • FFelix's avatar
        FFelix
        Frequent Visitor
        3 years ago

        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 

  • tmshah61's avatar
    tmshah61
    Regular Visitor
    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