Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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.
@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.
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.
@Anonymous
Also, give conditional formatting to font color using the same measure.