Forum Discussion
Solved
Conditional background color
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 conditio...
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
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 |
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