Conditional formatting from slicer with multi column

[aetherial]

hi,

Im new in Power BI and I would like to create conditional formatting for my dashboard with table below.

Currently I was able to make slicer from multi columns below ( Category A - D ) so whenever I select from slicer this will show any fruit name contain from all column.

Store Name	Category A	Cateogry B	Category C	Category D
Store A	Apple	Banana	Mango	Banana
Store B	Banana	Mango	Mango	Apple
Store C	Apple	Pinnaple	Apple	Apple
Store D	Mango	Strawberry	Stawberry	Banana

Next I would like to highlight selected fruit name with conditional formatting, so for example from slicer I check on Apple, this name from Category A - D will be highlighted. I just noticed conditional formatting menu in BI only for number not text.

Any advice on how to achieve this? appreciate if any help

[v-eachen-msft · Accepted solution]

Hi @aetherial ,

You could create a same table in query editor.

Then create a measure to define color in conditional formatting. 

Measure = 
IF(SELECTEDVALUE(Query1[Value])=SELECTEDVALUE('Table'[Category A]),"red")

Here is the result.

Here is my test file for your reference.

[amitchandak]

@aetherial , refer these for Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[mwegener]

Hi @aetherial ,

you can specify the formatting using a DAX calculation.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-...