Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hi KarenKu,
Report level filter can't operate logic such as "or", so you should use measure instead.
Regards,
Jimmy Tao
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.
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?
Hi KarenKu,
Report, page level filters can be used in your senario, you may use advance filter to achieve your requirement.
Regards,
Jimmy Tao
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.
Hi KarenKu,
Report level filter can't operate logic such as "or", so you should use measure instead.
Regards,
Jimmy Tao
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.