Conditional Formatting

[Anonymous]

Hi,

I was trying to implement some conditional formatting on power bi with a data set showing color codes on each cell instead of text. I tried doing it by conditional formatting option in power bi but unable to get desired results. Can someone guide me how i can achieve this in power bi, picture attached below.

1 Table - Normal data set

2nd Table - Desired Data table with color code for WFH and Office 

Any help would be highly appericiated. Thanks

[grazitti_sapna]

Create Measure for each column in the table Status color =

var selected_status = SELECTEDVALUE('Conditional Formatting'[1_April])

return

if(selected_status= "WFH", "#D5D8DC",

   if(selected_status="Office", "#F4D03F","#FDFEFE"))

Right Click on any of the following values and then select conditional formatting

Select background under conditional formatting

Select the field value under Format Style and apply to values only. Select the measure you have created for conditional formatting for that column.

[rajulshah]

@Anonymous 

Please create the following DAX measure:

Color Format =
VAR SelectedValue1 =
    SELECTEDVALUE ( 'Table'[ Field] )
RETURN
    SWITCH ( SelectedValue1, "WFH", "Orange", "Office", "Green" )

Go to the Conditional Formatting for this measure > go to Background Color > select Field Value > select this measure.
Do the same for the Font Color and you would be able to achieve the same.

Please let me know if this didn't work.

[Anonymous]

Hi, this way we will only get backgound color with text in it. The text is not getting replaced with color by following these steps.

[rajulshah]

@Anonymous 

Also, give conditional formatting to font color using the same measure.