IS IT POSSIBLE to apply a filter only to a section/category of the TreeMap?

[mario_ruiz]

Hi,

 I have 5 categories as 0,1,2,3,4 ... I would like to apply a filter by using specific fields when the user clicks over the 0 category of the treemap, is that possible? Actually, any filter I apply will affect the whole treemap.

Thanks.

Mario Ruiz

[amitchandak]

@mario_ruiz , Create a measure like

if(selectedvalue(Table[Category]) = 0 , [Measure], [Other measure])

[mario_ruiz]

ok, will do a try. Also I was trying to add a Metric into the category of the treemap but is not possible so is there a way I can create a column based on this Metric so I'm able to add it as a category in the treemap?

[mario_ruiz]

will create this as a new question, thanks.