Adding one more column in matrix visual

[schandrashekar]

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

What am I missing?

[HarishKM]

@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 🙂

[schandrashekar]

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]

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]

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 

[AlanP514]

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

[danextian]

I am assuming those columns are the items inside a column. If that is so,  adding one more column will only create a hierarchy.  But not enough information given it is only an assumption. Please provide more context to your use case

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/3250...