Only show data when I turn on filter

[Syndicate_Admin]

Hello, good afternoon

I have a query that I have not been able to resolve...

In my report I use a Filter, Text Filter (added), and below a table. When I put a piece of data in that filter, it throws me the results in the table of what I'm filtering. But what I want is that if there is no value in the Filter (that is) this empty, the table is blank, empty. Today if I don't have anything in the filter, it shows me all the data in the table, but since it is a query report I want the table to be activated only when asked.

Do you know if that can be done? I have searched the Web and Youtube and I can't find the answer.

Thank you very much for the help!

Diego

[Syndicate_Admin · Accepted solution]

Thank you! the contribution was very useful, and the video shared. Therein lies the solution!

Greetings and see you soon!

[v-rongtiep-msft]

Hi @Syndicate_Admin ,

I have created a simple sample, please refer to it to see if it  helps you.

Create a measure.

Measure =
VAR _1 =
    SELECTEDVALUE ( 'Table 2'[subject] )
RETURN
    IF ( _1 = SELECTEDVALUE ( 'Table'[subject] ), 1, BLANK () )

Then filter the measure is 1.

I have also found a similar blog, pelase refer to it to see if it helps you.

Show or Hide a Power BI Visual Based on Selection 

Best Regards

Community Support Team _ Polly

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