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" like, 201112,201212,201312,201412,201512,201612,201712,201808.

 

And plan to crate I colum "IsCurrentMonth" = 'Y'

I want use (YearMonth like '%12' OR IsCurrentMonth ='Y') to filter the data, and the chart will show correctly.

 

But, My question is the filter plane on the UI seems can not use "or" between two conditions?

What can I do? Or does Power BI Team have plan to enhanve this feature?

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

6 Replies

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