hide a text box if a Tablix shows "NoRowsMessage" or has not rows in PBI report builder

[OlegV]

Hi,
In Power Bi report builder, I need to hide a text box if a tablix shows "NoRowsMessage" or does not have any rows.

I've tried different options,none of them worked. I pasted them into Properties->Visibility->Hidden->Expression
=IIF(CountRows("DataSet1") > 0, False, True)
=IIF(CountRows(Fields!Title.Value, "DataSet1") < 0, True, False)

Please tell me a solution. 

[v-xiandat-msft]

Hi @OlegV ,

Below is my table:

The following Expression might work for you:

IIf(IsNothing(First(Fields!NewColumn0.Value, "DataSet1")) , True , False)

The final output is shown in the following figure:

Best Regards,

Xianda Tang

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

[OlegV]

@v-xiandat-msft 

Hi, Xianda,

thank you. It does not work, it doesn't hide a text box. I've already leant how to hide Tablix when there are not rows. Now I need to hide other texboxes on the report, when a Tablix does not have rows)

I have
1) a Tablix, with data, and
2) a text box in the footer, with an expression showing a date.

When I filter data and there is no rows in the Tablix, I want to hide a textbox with a date.

If there are rows, I want a text box to be shown.