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
Icon for Resolver II rankResolver 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?