How to change conditional formatting rules for some rows?

[Anonymous]

Hi!

For my work I should create a table with two color groups in conditional formated columns. For this moment you can see column with one rules group. I use here conditional formatting filters, but for some rows in this column I should use other filtering colors, with same filter values. Could you tell me, is it possible? Here is color rules too...

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, I suggest you to create the same filter value by dax formula(measure or calculated column) in the table, and you could use another conditional formating rules for the copied column.

Sample data:

Measure:

Measure = CALCULATE(SUM(Table1[Value]))

Calculated column:

Column=[Value]

Set the different conditional formatting:

If I misunderstood you, could you please offer me more information about your data structure?

Regards,

Daniel He