Dynamic previous month name in column header

[Anonymous]

i have slicer visual to select the month 

i have below table visual which provides selected month and previous month of the selected month sales as below

i want replace column header with slection month names example if i select june in slicer then

Selected month sales name should be replaced with June month sales

Previous month sales name should be replaced with May month sales (as prvious month of may is june)

How can i change the column names dynamically based the selection in the slicer   

[amitchandak · Accepted solution]

@Anonymous , the Measure name can not be dynamic yet. You can only create a dynamic title as of now.

Measure = format(maxx(allselected('Date'), 'Table'[Date]), "MMM-YYYY")  & " vs" & format(eomonth(maxx(allselected('Date'), 'Table'[Date]),-1) , "MMM-YYYY")

[parry2k]

@Bharathi_99 did you check the video posted in my previous reply? 

[parry2k · Accepted solution]

@Anonymous check my blog post here Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions, I have done the similar to show previous year and current year, you can use the same technique for the previous month and use it in any visual.

✨ Follow us on LinkedIn and subscribe to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Thanks @parry2k  for the solution.

[amitchandak · Accepted solution]

@Anonymous , the Measure name can not be dynamic yet. You can only create a dynamic title as of now.

Measure = format(maxx(allselected('Date'), 'Table'[Date]), "MMM-YYYY")  & " vs" & format(eomonth(maxx(allselected('Date'), 'Table'[Date]),-1) , "MMM-YYYY")

[Bharathi_99]

Hi ,
I want to get previous month name dynamically for the selected month
Like if I select vmarch-2022 it must show Feb 2022 as column header
I'm trying to create it in field paramaetres but it's not affecting correctly
.
Please help me

[Anonymous]

Thanks @amitchandak created dynamic measure for month and used card visual 

[SB4]

I am doing this exact thing but the issue I have is.....my matrix with headers is quite wide and has horizontal scrolling.  I have 12 card visuals to use as dynamic headers but when the matrix is scrolled right or left....the card visuals do not scroll with it.  Did you have this issue?