topic Re: Conditional background color in Developer

Conditional background color

manojk_pbi — Sat, 06 Jul 2024 16:46:48 GMT

Hi ,

I have a table with few columns out it couple of columns need to have background color based on condition. Sample data in the table is as below. Pls guide me how can we add multiple conditions

Color coding

Expected result - color coding will be based on the status color defined above and background color should be added where a text is found in Remarks column & rest will be no-color

Re: Conditional background color

foodd — Sat, 06 Jul 2024 16:57:33 GMT

Hello @manojk_pbi , remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Re: Conditional background color

manojk_pbi — Sat, 06 Jul 2024 17:15:56 GMT

Attached the sample data. The required out is to just fill the background for Remarks column based on 2 conditions. First condition is Remarks should not be blank or empty and then apply color code based on the status.

Task	Status	Remarks	Trend	Date
T1	In-Progress	waiting	Increasing	24-Jan
T2	Active		Increasing	24-Jan
T3	Resolved	in Tetsing	decreasing	24-Jan
T4	New		decreasing	24-Jan
T5	Closed	issue fixed	decreasing	24-Jan

Re: Conditional background color

Anonymous — Tue, 09 Jul 2024 09:56:00 GMT

Hi @manojk_pbi ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create a measure as below

Conditional formatting = VAR _remark = SELECTEDVALUE ( 'Table'[Remarks] ) VAR _status = SELECTEDVALUE ( 'Table'[Status] ) RETURN SWITCH ( TRUE (), _remark <> BLANK () && _status = "In-Progress", "Yellow", _remark <> BLANK () && _status = "Active", "Blue", _remark <> BLANK () && _status = "Resolved", "#89D26B", _remark <> BLANK () && _status = "New", "Grey", _remark <> BLANK () && _status = "Closed", "Green" )

2. Apply conditional formatting

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards