Conditional Format the rows in a matrix Table

[jyothish8807]

Hi All,

I have a matrix table in the below format where "List, Cource and Target" are rows and A,B,C values are coming from column "User" and "Status" field is the values (Completed, pending etc).

Now, is it possible to provide a conditional formating on "Target" column which is a direct column in the chart based on the no "complted" status ?

If Count of Status with "Completed" value is  < Target then Red.

Thank you in advance !

@Ahmedx 

Br,

KC

[jyothish8807]

Hi All,

Please find below a sample data for your reference, i want the output in the a matrix table as my user list is dynamic and have to use them as columns in a matrix table.

Thank you !

T1

List	Course	Target
List 1	Training 1	2
List 1	Training 5	2
List 2	Training 2	2
List 2	Training 8	2

T2

Course	User	Status
Training 1	A	Completed
Training 2	A	Completed
Training 3	B	Pending
Training 8	C	Completed

[Anonymous]

Hi, jyothish8807

Based on the information you provided, I created a Table.

You can see the background color in the Cell elements and can customize the changes to the Target column.

But you are in Matrix, so if you can provide me with the relevant Table, I can make further changes in Matrix.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @jyothish8807 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[jyothish8807]

Hi @Ritaf1983 ,

Please find below a sample data for your reference, i want the output in the a matrix table as my user list is dynamic and have to use them as columns in a matrix table.

Thank you !

T1

List	Course	Target
List 1	Training 1	2
List 1	Training 5	2
List 2	Training 2	2
List 2	Training 8	2

T2

Course	User	Status
Training 1	A	Completed
Training 2	A	Completed
Training 3	B	Pending
Training 8	C	Completed