X Axis using selected month as M and then M+1, M+2 and so on (to compare 2 years of orders)

[KS_learner]

Hi

I want to visualize the below chart in PowerBI for every selected month.

For eg if the selected month is Aug (for order date) 

Aug = M

Sep = M+1

Oct = M+2  and so on.

Similarly if selected month is Jul

Jul = M

Aug = M+1

Sep = M+2 and so on

The idea is to compare data for two years

is this possible? if yes is it very complicated.

[v-luwang-msft]

Hi @KS_learner ,

You need to create a slicer base on base table ,and then use a measure to filter table. Due to not with your base table ,you could refer the below:

Create slicer table:

Slicer = SELECTCOLUMNS('Table',"Month",'Table'[month])

Create filter measure:

filter = IF(MAX('Table'[month])>=SELECTEDVALUE('slicer'[month]),1,0)

Output result:

Best Regards

Lucien 

[KS_learner]

thanks! But i think i forgot to mention that the X axis is the requested date and the filter needs to be the order date. so the dates are 2 separate dates. do you know how to do that?

[KS_learner]

also the increment can be beyond 12 as well. So for eg - if a customer places an order in Sep'22 he could request it even in Oct'23. So the X asix should show customer requested date all the way to M+13 in this case (M being Sep).. is my question clear?