Forum Discussion

Rohit001's avatar
Rohit001
Helper 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 ...
  • rajendraongole1's avatar
    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!!