Custom legend change automatically by month

[ThuJa23]

Hi Everyone, 

I have created 2 measures to display order value of next month and next 2 months from this month

Ord val next month = CALCULATE (  [Ord Val],  NEXTMONTH('Date'[Date]), Snapshot[Name] = "Actual date")

Ord val in next 2 months = CALCULATE([Ord Val], DATEADD('Date'[Date],2,MONTH),Snapshot[Name] = "Actual date")

Then I displayed in chart as below

I rename the names of value in chart from "ord val next month and ord val in next 2 months" into "current mth + 1, current mth + 2".

However, I would like to ask - can we custom legend by dax or anyway that show the month name automatically?

For example: If current month (which is selected in filter) is October, then the above chart can display in legend information with

- black bar: November

- grey bar: December

Does anyone have idea about this, please share with me

Thanks so much for your replies

Br

Thu

[amitchandak · Accepted solution]

@ThuJa23 , Measure label rename is not supported as of now. You can try with independent date table and display +2 months

refer

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

[ThuJa23]

Hi @amitchandak ,

Danke for the information. I will check the link 🙂