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 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,

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,

     

1 Reply

  • 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,