Conditional Format the rows in a matrix Table

Question

Hi All,&nbsp;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&nbsp; &lt; Target then Red.Thank you in advance !Ahmedx&nbsp;&nbsp;Br,KC

ritaf1983 · Answer

Hi&nbsp;jyothish8807&nbsp;
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

anonymous · Answer

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.

&nbsp;

But you are in Matrix, so if you can provide me with the relevant Table, I can make further changes in Matrix.
&nbsp;
&nbsp;
&nbsp;
How to Get Your Question Answered Quickly&nbsp;
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&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

jyothish8807 · Answer

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.&nbsp;Thank you !T1ListCourseTargetList 1Training 12List 1Training 52List 2Training 22List 2Training 82&nbsp;T2CourseUserStatusTraining 1ACompletedTraining 2ACompletedTraining 3BPendingTraining 8CCompleted

jyothish8807 · Answer

Hi Ritaf1983&nbsp;,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.&nbsp;Thank you !T1ListCourseTargetList 1Training 12List 1Training 52List 2Training 22List 2Training 82&nbsp;T2CourseUserStatusTraining 1ACompletedTraining 2ACompletedTraining 3BPendingTraining 8CCompleted

Forum Discussion

Conditional Format the rows in a matrix Table

4 Replies

Related content

Matrix Row Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting with Matrix Table

Conditional Formatting

Conditional Formatting

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

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