multiple column filter

[Anonymous]

Hi all,

Outstanding Item list:

I have a treemap which is set drill through to page 2. Page 2 have outstanding item list. How can I set a filter for multiple column for outstanding item list? 

For example, when I drill through project 7, B27 it will show all the list of outstanding item for that specific project only. I want to see the list of outstanding item no.

Hope you can help. Thank you.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could try creating two independent slicer tables and a measure like:

Measure = IF(selectedvalue(Item[code]) = selectedvalue(slicer1[project code])||selectedvalue( Item[code]) = selectedvalue(slicer2[batch code]),1,0)

Add this measure to visual filter set value = 1.

Best Regard,

Jay