Display blank visuals until user selection

[Tevon713]

Hi all.

I need help trying to display blank visuals until user selection. Currently when no filters selection it will display all the data.

Duplicated effort found on this thread here: https://community.powerbi.com/t5/Service/Want-visuals-to-be-blank-until-i-select-an-option-from-the-...

Dropped in "Hide Visual" measusre to the visual filter and set to 1, nothing happen.  When set to 0 it does hide and will not populate.. so that is not correct. Maybe I'm missing something?

Also wanted to know how to set ISFILTERED for multiple filters?  Thank you all in advance

Measures:

Check Filtered = ISFILTERED('Test DATA'[Site Name])

Hide Visual = IF([Check Filtered],1,0)

Make Transparent = IF([Check Filtered],"#FFFFFF00", "White")

PBI

[Anonymous]

Hi  @Tevon713 ,

Here are the steps you can follow：

1. Create measure.

Flag =
CALCULATE ( IF ( ISFILTERED ('Test DATA'[Site Name] )||ISFILTERED('Test DATA'[Region]), 1, 0 ), ALLSELECTED ( 'Test DATA' ) )

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

When not selected:

After selecting:

If you need pbix, please click here.

Best Regards,

Liu Yang

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

[Tevon713]

Thank you very much @Anonymous. Curious if the mesaure "Flag" not part of the Table column display then the measure will not work for none selection?

[amitchandak]

@Tevon713 , Try like

Check Filtered = calculate(ISFILTERED('Test DATA'[Site Name]), allselected())
Hide Visual = IF([Check Filtered],1,0)
Make Transparent = IF([Check Filtered],"#FFFFFF00", "White")

or

Check Filtered =int( calculate(ISFILTERED('Test DATA'[Site Name]), allselected()) )

Make Transparent = IF([Check Filtered]=1,"#FFFFFF00", "White")

[Tevon713]

Thanks @amitchandak. I tried both your suggestion, still not hiding when none of the filters were selected.

Here's the test data pbix: https://www.dropbox.com/s/y4vo8krty7muv2v/Testing%20HideVisuals.pbix?dl=0