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

praiselyabraham's avatar
praiselyabraham
Resolver II
8 years ago

Hi , 

 

I just created a coupple of columns that has year, month  information  and then created a flag column

 

Axis Value = IF(OR([Month]=12,[YearMonth]=MAX([YearMonth])),1,0)

 

Hope this solves your issue

 

 

Regards.

 

KarenKu's avatar
KarenKu
Regular Visitor
8 years ago

Hi, Thanks for your replay, 

 

But I want to know that is there have a way to use in the filter panel, not create a new calculated column?

 

 

 

 

 

 

 

 

  • praiselyabraham's avatar
    praiselyabraham
    Resolver II
    8 years ago

    In the filter section , that cant be added as you are looking for the max month in the current year, and these aggregative functions dont apply in this section. 

  • 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