Forum Discussion
Display blank visuals until user selection
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-table/m-p/2352367#M152447
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:
4 Replies
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")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
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
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?
