Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

hidden graphic

I need to create a dashboard where must have an object that is like a filter and it will have a list of users and clicking on any of these user a new object must come up with the detailed of the same...
Need Help
KumarDarmesh's avatar
KumarDarmesh
Helper IV
10 years ago

chrisu

 

I set the v-level filter(selected='Y') however the table displays all items when no any item selected in the slicer.

Can you be more specific?

chrisu's avatar
chrisu
Responsive Resident
10 years ago

Hmm that is probably because you are filtering by user in the table, so for each row of the table the filter context means that one user is selected and the measure evaluates to Y.  Do you have some other user-specific field (like UserID) that you aren't displaying in the table?  If so, you can change your measure to evaluate whether that has one value and it should work.  

 

You could also change your measure to something like the following to force PowerBI to look at the broader filter context of Users rather than row-by-row in the table:

 

=if(calculate(distinctcount([User]),allselected([User]))=1,"Y","N")