I encounted a problem. I want to use each December of years or the lastest month current year on x-axis on my chart.
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.
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
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.
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.