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/.
Chris,
Exactly I was looking for. I'll go ahead and look into implementing these for all of my visuals that I need to be filter dependent. Thank you!
Helper IHi Anonymous, Anonymous,
I need some help from you all. I need to hide my data from Card Visual chart in Power BI at initially in dashboard. I used some slicers for filters in my report. I want to show my card visual data while I am being selected some values from slicers.
Please find the attachment for the reference. I want to show no. of units based on product release and ceiling type charts data labels either should be hide initially or should be shown balnk value. If I would apply any filter from product release and ceiling type then my data should be shown.
As per below picture, it shows all units values even if I dont apply any filter.
Could you please kindly help me that how to resolve this issue in power bi.
Thanks in advance.
Thanks & Regards
Sridevi
Sridevi,
Were you able to create the measures in order to hide your data until filtered? If not, reply to this and I'll be happy to assist if I can.