Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Matrix - Different conditional formatting for each column

Hello,

 

Is it possible to add conditional formating for matrix values, but assign different conditions for each column?

Conditional_column.JPG

In first matrix, you can see the result if I apply the conditional formating to Size value, but the background color scale is calculated over all the columns.

 

I would like to obtain the result that I show in the second matrix, applying the scale color indivually to each Column.

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

As tested, it seems impossible.

Only i can get is as below

3.png

Best Regards

Maggie

 

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

Anonymous
Not applicable

Hi @v-juanli-msft,


You get the same result as me, but unfortunately this doesn't help me for what I'm looking for.

I'm trying to emphasise the file Size when it has a very different value compared with the other days.
The only solution that I see is to create a measure for each file, but this means a lot of measures and modify the report each time that I change the process.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.