Tree Map not filtering

[Anonymous]

Hi,

So I am having an issue with my Treemap. My other visuals such as a map, pie, bar chart all filter fine. I click on the category and it it changes all visuals to show only rows wich correspond with the category selected on that particular visual. 

However, on my tree map I can't seem to get it to work. The main difference with the other visuals is that the treemap uses different columns with either 1 or 0. So around 10 columns with each 1/0. I tried changing this to True/False, actual names, changing 0 to null but nothing works. See picture with part of the columns representing these 1/0.

I'd like to click on a tile and have the dashboard show all rows that have a 1 in that cell. 

Notes:

- Its only one table so there is no need for linking between tables

- Edit interactions makes no difference, would be weird as all the other visuals worked automatically. 

Thanks in advance!

[Anonymous]

Hi @Anonymous,

So you mean to create a treemap visual to show all fields as the category which not equal to zero?
If that is the case, you can enter to query editor and do 'unpivot columns' on these value fields to convert them to attribute and value.

Unpivot columns (Power Query) 
After these steps, you can create a tree map with attributes on the group, the value on value fields. (you can use the value field on filter to filter records that equal to zero).

Regards,
Xiaxoin SHeng

[Portrek]

Yo can make a conditional measure like

Measure: If ( table(column) = 0, Blank (), table(column))

See you !

[Anonymous]

Thanks for the suggestion, im new to Power Bi so not entirely sure where to place the measure. Should I create one nested if measure and apply it to each visual or only the tree map?