Forum Discussion
Conditional formatting from slicer with multi column
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
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.
3 Replies
aetherial , refer these for Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
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/811692Hi 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.
