Forum Discussion
Solved
Matrix Table Visual Breakdown/Drilldown by Column
Hello, I have a question about splitting data in a matrix table visual. My data table contains spend and expense data for different managers across different years. I am trying to pres...
1. Go to Power Query Editor, select expense and sales column, unpivot those columns.
2. Create a new table for replace the blank space in the Matrix.
*Home - select create newtable. Enter column name Project Mgr and their name.3.Once you created a table, create a measure in the new table, using this formula
Measure = SUM(Sheet8[Value])+04. Then, form the matrix like below, you will get the desire output.
Either change the value display to "Switch values to rows" or use custom column headers.