Filter panel Can I use Two Columns with OR logic

[KarenKu]

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?

[praiselyabraham]

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]

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?

[v-yuta-msft]

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]

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 · Accepted solution]

Hi KarenKu,

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

Regards,

Jimmy Tao

[praiselyabraham]

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.