Forum Discussion

KarenKu's avatar
KarenKu
Regular Visitor
8 years ago
Solved

Filter panel Can I use Two Columns with OR logic

I encounted a problem. I want to use each December of years or the lastest month current year on x-axis on my chart. For example,  I have one column "YearMonth", and I want presenting "YearMonth" l...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi KarenKu,

     

    Report level filter can't operate logic such as "or", so you should use measure instead.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi KarenKu,

 

Report, page level filters can be used in your senario, you may use advance filter to achieve your requirement.

 

Regards,

Jimmy Tao

KarenKu's avatar
KarenKu
Regular Visitor
8 years ago

Hi

 

I want to achieve, like (YearMonth like '%12' OR IsCurrentMonth ='Y') effect in filter section. I use two different columns in a criterion.

 

Can advane filter achieve my requiement? I didn't understant how can I do.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi KarenKu,

     

    Report level filter can't operate logic such as "or", so you should use measure instead.

     

    Regards,

    Jimmy Tao