Forum Discussion
Solved
Dynamic Filter based on another Filter
I have a report that has a table that shows open purchase orders. Purchaing manager then has a set of filters that shows problematic line items. I would like to take the list of purchase order number...
Hi MichaelDWebb
No worries. Just change the Check measure as follows
Check =IF (ISFILTERED(POS[PO]) ,IF(VALUES(Data[PO]) in Values((POS[PO])), "Y","N"),"N")This will work even if there are mutiple selection on POS[PO].I have added one more "N" to tell that if none is selected the entire Data Table will be displayed.CheersCheenuSing
Thanks for this tutorial, opened up some new ideas for me. I was able to make this work, per your instructions. Unfortuanately, I did not clarify that I need to be able to select multiple values on the slicer.
Hi MichaelDWebb
No worries. Just change the Check measure as follows
Check =
IF (ISFILTERED(POS[PO]) ,
IF(VALUES(Data[PO]) in Values((POS[PO])), "Y","N"),"N"
)
This will work even if there are mutiple selection on POS[PO].
I have added one more "N" to tell that if none is selected the entire Data Table will be displayed.
Cheers
CheenuSing
Hi Anonymous,
Thank you, this worked perfectly. Is there a way to auto check all of the items on the slicer?
Thansk,
Mike
Hello, can I do this with categorical variables, instead of 102..101 I have Product_1, product_2...
Regards
Anonymous