How to Display an Empty Table Chart When Filter is Unset

[puru85]

Hello Experts,

I have a Table Chart and Filter Chart , Refer to below screenshot:

Current Behavior:
When the Phone Number Search Filter is empty, the Table Chart displays all the data.

Required Behavior:
I need the Table Chart to be empty when the Phone Number Search Filter is not set.

Attached is my PBIX:

FamilyKey.pbix

Could anyone guide me on how to achieve this? Any help would be greatly appreciated!

Thank you!

[puru85]

@AnkitaaMishra 

Thank you for Quick Solution 🙂 

[AnkitaaMishra · Accepted solution]

hi @puru85 , hope you are doing well.

please create below measure : 

Filterselected =

IF(

    CALCULATE(ISFILTERED('Family Members Table'[Phone Numbers]),ALLSELECTED('Family Members Table'[Phone Numbers])),

    1,

    0

)

Use above measure to filter for your table visual and set it to 1 as shown below : 

Please let me know if this works for you else share more details about your requirement.

Thanks,

Ankita