Forum Discussion
How can I hide data from populating Visuals until I filter it in?
I do the same thing when reporting survey data. All visuals are blank until a user selects a question from a slicer. To do this, I first created a measure using IF and HASONEFILTER to check whether one question is selected:
QuestionSelectCheck = IF(HASONEFILTER(SurveyQuestions[Question]),"1","2")
Then, for each visual, I drag that into the visual level filters box and set it to display if QuestionSelectCheck = 1.
Note that this doesn't remove everything (headers and titles and what not are still there for each visual), but it does remove all the data from the visual.
Depending on your specific needs, you may need HASONEVALUE, ISFILTERED, or even a COUNTA/DISTINCTCOUNT instead of or in addition to HASONEFILTER. See http://www.powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/.
chrisu Anonymous
I have been working on some thing similar to what you have shown below . I have created a measure using HasOneFilter and dragged it to visual filters and set it to display 1 . It is working as expected. However, Select All is not coming back with any results.
Select All and selecting None are not showing up any thing on charts and data will generate in charts only when we select something from filters. Is there a reason for that ? Why arent we seeing any thing when I choose Select All from filter ?
Please assist me with this !!!
The reply may be a bit late but i just found a solution that worked for me.
All other solutions just gave me either all 1 or all 2regardless if i selected anything or not
Selection Check = IF(CALCULATE(HASONEVALUE(Employee[Name]); ALLSELECTED(Employee)) = TRUE(); 1;2)
I am from germany so i am using ";" instead of ","
Hope this helps someone :)
Helped me,
Thanks