Forum Discussion

Rohit001's avatar
Rohit001
Icon for Helper I rankHelper I
2 years ago
Solved

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 ...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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!!

     

     

     

Anand24's avatar
Anand24
Icon for Super User rankSuper User
2 years ago

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.