line chart visual level filters

[Anonymous]

Hi All, I have created a line chat and want to create a visual level filter for a column that contains Y/N values only. In the filer when I try to show items where the value is Y it will not let me apply the filter. For the field in the values placeholder I have select count of the values so not sure if this is affecting it. Can sombody help here with a suggested new measure of way to add the required filter. Thanks,

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

First way,you may drag the Y/N column to the visual level filter and set it is Y.

Second way,you may create a measure and drag it to visual level filter to set it is 1.

Measure = IF(MAX(Table1[Y/N])="Y",1)

Regards,