Can i make a Conditional Format to Color the cell & font of the Text Value in aTable with its color

[eghusseinr]

Hello guys 

I am connecting this PBI to sharepoint Data Source, and below detatils for all columns from ITG0 till Product Management, are Text values.

My question can i make one Meassure that could be used for Makeing "Backgroud & Font" conditional format to highlight the cell it seld with the same text color in it?

pic 2 is showing what i aim to have ...

[christinepayton]

You would have to change the shape of your data table to do it all with one measure. You could unpivot all of those columns that have color in your example, giving you a value column and an attribute column. Use the attribute column as the "columns" in a matrix visual (instead of a table) and put the value column in the values well. Then you can make one conditional formatting rule to affect all columns at once. 

[ray_aramburo]

You can do it without measures but would require doing it per column.

Here's how:

Select the column options > Go to Conditional Formatting > Background Color (or font color)

Select format syle by Field value and click Ok.

Here's what you would get:

Repeat the steps for the font color and for each column.

Note: This will work automatically as long as the values are correctly named (not spelling errors). 

[eghusseinr]

Hi @ray_aramburo 

can you share the expamle file with me, bcause i the feauter of sellecting the "First Category expamle" is not avilabe in my Desktop PowerBI !!

[ray_aramburo]

It won't appear as First Category as that was the name I was using for a column. In your case it would be First Project Schedule, as an example. 

I attached my example file for your reference 🙂