Forum Discussion

aetherial's avatar
aetherial
Regular Visitor
6 years ago
Solved

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 whenev...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

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.