Unable to get all rows of data in a matrix and unable to apply background color for rows in a matrix

[sirisha_]

If the table visual contains the following columns: Client, Area, Country, Status, Project Manager, Head Cound, Start date, Live date, and End date. And if we try to filter it using Client and Country. The data comes in two rows.

We only receive one row of data if we transform that table's visual to a matrix. Since the client, area, country, status, start date, live date, and end date are all the same.

Matrix rows: Client, Area, Country, and Status
Matrix Values: Head Count, Start date, Live date, End date, and Project Manager

It displays two rows if the project manager is kept in the matrix rows. However, the same problem exists if project manager also contains duplicate values. Please refer to the image 1. But expected output is 3rd table which is shown in image 1.

Updating the data for reference:

Client	Area	Country	Project Manager	Status	Head Count	Start Date	Live Date	End Date
ABC	AMERICAS	Canada	Chris	In Progress	23	30-Nov-19	11-Dec-19	02-Dec-20
Quality Contacts	AMERICAS	New York	Chris	In Progress	9	16-Dec-19	19-Dec-20	27-Dec-20
Total Trust	APAC	Hong Kong	Sam	Not Started	34	03-Jan-20	05-Jan-20	19-Jan-20
Pure Service	APAC	Japan	Erin	Yet to Start	89	16-Jan-20	25-Jan-20	30-Jan-20
Total Trust	EMEIA	Kenya	Erin	Live	25	20-Jul-21	26-Jul-21	30-Jul-21
Total Trust	EMEIA	Kenya	Sam	Live	67	20-Jul-21	26-Jul-21	30-Jul-21
Pure Service	APAC	Malaysia	William	On Hold	12	25-Jul-22	05-Aug-22	11-Sep-22
Quality Contacts	APAC	Australia	Chris	Yet to Start	54	12-Aug-22	17-Aug-22	29-Aug-20
ABC	APAC	Malaysia	William	Live	93	05-Nov-22	09-Nov-22	25-Nov-22
Quality Contacts	EMEIA	Denmark	Sam	Not Started	29	14-Nov-22	18-Nov-22	01-Dec-22

Another issue is the status column of rows in a matrix. Unable to apply conditional formatting to rows in a matrix or apply background color, please see the attached image 1, and the third table is the desired result.

Currently, status column is taken in rows but I don't find anything to apply conditional formatting or background color.

If that status is moved to values of a matrix, then we can apply conditional formatting.

Matrix ValuesMatrix visualMatrix rowsImage 1

Please assist me if anyone have any suggestions or ideas for how to resolve this. 

Thanks & Regards,
Sirisha.

[olgad]

Hi, a couple of questions, if in the end your matrix shall look like your table, why cant you use the table visualisation? You could color your Status there easily. There is no way to color the matrix rows by default, this is a feature much desired by all. 

Matrices work this way, they aggregate, tables show you values row by row. 

What is your purpose trying to use a matrix?

[sirisha_]

Hi @olgad, thanks for responding.

In order to freeze a few columns in a table visual, which is not possible, I am transforming the table visual into a matrix visual.

Therefore, I'm attempting to accomplish the same thing in Matrix where I can freeze the Client, Country, Status, and other columns. As a result, it meets the criteria. This is why I can't use conditional formatting in a matrix. I can perform it at a table.