cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KarenKu Frequent Visitor
Frequent Visitor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filter panel Can I use Two Columns with OR logic

Hi KarenKu,

 

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

 

Regards,

Jimmy Tao

6 REPLIES 6
praiselyabraham Regular Visitor
Regular Visitor

Re: Filter panel Can I use Two Columns with OR logic

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

 

Capture.PNG

 

Regards.

 

KarenKu Frequent Visitor
Frequent Visitor

Re: Filter panel Can I use Two Columns with OR logic

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?

 

 

FilterPanel.JPG

 

 

 

 

 

 

Highlighted
praiselyabraham Regular Visitor
Regular Visitor

Re: Filter panel Can I use Two Columns with OR logic

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. 

Community Support Team
Community Support Team

Re: Filter panel Can I use Two Columns with OR logic

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 Frequent Visitor
Frequent Visitor

Re: Filter panel Can I use Two Columns with OR logic

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.

Community Support Team
Community Support Team

Re: Filter panel Can I use Two Columns with OR logic

Hi KarenKu,

 

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

 

Regards,

Jimmy Tao