Formatting single row data using column data

[Hari01]

Hi

I have table viz and sample is like below. All products are categories into 3 and they are A, B and C.  I have to formate font or bacground color of rows for Category A.

Is it possiable in Power BI to formate some rows based on column Category data ?

ID	Name	Category
1	Sofa	B
2	Chair	A
3	Glass Table	C
4	Table Top	C
5	Writing Desk	B

Thanks in advance! 

[v-yadongf-msft · Accepted solution]

Hi @Hari01,

Please try following DAX to create a new measure:

Measure = IF(MAX('Sheet1'[Category]) = "A","yellow")

Right click and select "Conditional formatting":

Select "Field value" - "Measure" (just created):

Result you want:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sevenhills]

It can be done by adding a measure, which is explained in the link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Section: Color-code based on text

Hope this helps!