Forum Discussion

puru85's avatar
puru85
Icon for Helper II rankHelper II
2 years ago
Solved

How to Display an Empty Table Chart When Filter is Unset

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!



Need Help
Show and Tell
  • AnkitaaMishra's avatar
    AnkitaaMishra
    2 years ago

    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

2 Replies

  • AnkitaaMishra's avatar
    AnkitaaMishra
    Icon for Super User rankSuper User
    2 years ago

    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