Forum Discussion

belvoir99's avatar
belvoir99
Icon for Resolver III rankResolver III
3 years ago

Select All vs selecting nothing

Re slicer selection: Has anyone found a solution to the problem of distinguishing between selecting all the values on a slicer and selecting no values?   Specifically, when the user de-selects the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi belvoir99,

AFAIK, current filter functions are hard to recognize the difference between not selected and allselected(the default status). So the top two scenarios are equivalent for Dax ISFILTERED function.
My formula can be used to recognize the manually selected on the filter items except 'select all' option.
Regards,

Xiaoxin Sheng

belvoir99's avatar
belvoir99
Icon for Resolver III rankResolver III
3 years ago

Thanks Anonymous Xiaoxin! I suspected there wasn't anything else possible but it was good to hear from you!

I won't mark this as a solution because it hasn't solved the problem.

 

Power BI tries to keep separate dashboard objects and their properties from DAX code and the data. However, it means that it is very limited in manipulating objects according to data value (via DAX).