Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Question regarding the matrix table


What I have right now is the visualization on the left side and I'm trying to accomphish the look of the one from the right side. As you can see right now there is the "Objective" for every quarter. However, if i'm trying to get the same looks as the one from the right I have to remove those reducdant column and only show the total for "Objective" 

Thank you everyone in advance 🙂

matrix

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Greg_Deckler 
      I believe the information on your link is what i was looking for. However, could you explain me a little bit more regarding this dax

       Custom Hierarchy =
      {
      ("2019", "January", 1),
      ("2019", "February", 2),
      ("2019", "March", 3),
      ("2019", "April", 4),
      ("2019", "May", 5),
      ("2019", "June", 6),
      ("2019", "July", 7),
      ("2019", "August", 8),
      ("2019", "September", 9),
      ("2019", "October", 10),
      ("2019", "November", 11),
      ("2019", "December", 12),
      ("2020", "January", 1),
      ("2020", "February", 2),
      ("2020", "March", 3),
      ("2020", "April", 4),
      ("2020", "May", 5),
      ("2020", "June", 6),
      ("2020", "July", 7),
      ("2020", "August", 8),
      ("2020", "September", 9),
      ("2020", "October", 10),
      ("2020", "November", 11),
      ("2020", "December", 12),
      ("Other", "LY", 13),
      ("Other", "PY", 14)
      }

      I'm wondering how do I implement this on my report.