cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
natjan Frequent Visitor
Frequent Visitor

How to change conditional formatting rules for some rows?

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...

 

columns.PNGrules.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to change conditional formatting rules for some rows?

Hi @natjan,

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:

1.PNG

Measure:

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

Calculated column:

Column=[Value]

Set the different conditional formatting:

2.PNG

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: How to change conditional formatting rules for some rows?

Hi @natjan,

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:

1.PNG

Measure:

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

Calculated column:

Column=[Value]

Set the different conditional formatting:

2.PNG

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: How to change conditional formatting rules for some rows?

Hi @natjan,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.