Issue: Matrix

[Rohit001]

I have an issue with a matrix visual. I am trying to create a matrix table visual where a group of years is combined with a single month. Which is dynamic, the scenario is every day data will be added but i have to show it in month wise if new month new year add then it has to  change

 getting above output
but i want to 

[Anand24]

@Rohit001 ,
I feel that the month sorting seems to be the issue. If that is the case, you can create a month sort table, connect it to original table and then pull month name from this new table.

This way the latest month will always fall in the end or start dpending on how you keep it.

Currently in your expected output, June is falling between April and May which should actually be April then May then June.

[rajendraongole1 · Accepted solution]

Hi @Rohit001 - create a new colum in your date table and add below logic in your calculated column .

Year_Month = 'Date'[Year] & "_" & 'Date'[MonthName]

use your matrix visual added year_month in columns and 

you can get the as expected output. check and let know

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Greg_Deckler]

@Rohit001 So, can you create a new column like FORMAT( [Date], "mmm_yyyy") ?