Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

line chart visual level filters

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 a...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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,

     

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

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,