Forum Discussion

schandrashekar's avatar
schandrashekar
New Member
3 years ago

Adding one more column in matrix visual

I am trying to add another layer on top of the existing column in my matrix but not working.

What am I missing?

 

6 Replies

  • schandrashekar Hello,
    You can create month column for your date . then drag your month (newly created column) to column of matrix then add your type column to see the data according to that. Kindly follow below image.

     

    Thanks 

    Harish M.

     

    Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos ğŸ™‚

     

  • Hai
    You can add other fields also to the column section then you have to enable rows or columns from above

    If this makes Insightsful, Kindly mark it as solution

  • I am trying to add the "First of month" as the 1st layer in columns and then CLient Type. But when I do that, it doesnt create Hierarchy and it overrides the already existing column.

    end result I want is, to have Months and CLient type, both in the columns

    • AlanP514's avatar
      AlanP514
      Post Patron

      Hi schandrashekar ,
      Please follow the steps
      1. Remove first of month
      2.Switch off Stepped layout option
      3. Add First of month column then you can able to see rows and column option above 

      please check and revert back to me 
      please disable stepped layout option

      • AlanP514's avatar
        AlanP514
        Post Patron

        HI schandrashekar 

        If you are okay, please remove sensitive data or create one dummy data  and kindly share pbix file, so that it would be more easier for understand the issue