Forum Discussion
Issue: Matrix
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
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!!
3 Replies
Rohit001 So, can you create a new column like FORMAT( [Date], "mmm_yyyy") ?
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!!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.
