Query on HASONEFILTER

[Nikita22]

Hi,

I have a dashboard where I have used "Card Visuals", "Table" and "Slicers". Now, I want my data to be displayed only when I'm applying the filter otherwise it should be blank. I have seen the videos for HASONEFILTER, ISFILTERED and HASONEVALUE but I don't know how to apply that Card visual.

Please help me out!

[v-yuezhe-msft]

@Nikita22,

I am not very clear about your requirement. What filter would you like to apply in the report? Which visual shows blank in this case?


Regards,
Lydia

[Nikita22]

Hi Lydia,

Thank you for your attention to my query.

I have a data of requests and I have made a dashboard to track the status of the request. I have put the request ID and requestor's name in slicers. So my query was - data should not display unless I select the ID or name. However, this query has resolved now by using below ISFILTERED measure.

Status = IF(ISFILTERER(Table1[Requestor],SELECTEDVALUE(Table1[Overall Status],"Please Select Ticket ID"),"Select Requestor's Name to view Status")

Now I can filter the requestor's name and view the details but I can not filter the data by request ID. So I want both the slicers to work. I have tried to do so with OR function but it didn't help me.

Please get back to me if you have a solution.

Thanks,

Nikita

[v-yuezhe-msft]

@Nikita22,

Could you please share PBIX file with sample data so that I can test?

Regards,
Lydia