Forum Discussion

mcantos's avatar
mcantos
Helper II
1 year ago

Conditional formating in a matrix using measures

 

Hi community, I need your help again.

 

I created a measure to use it in a matrix:

Then, I created the matrix using the values I got in my table "Opportunities": status, Current stage, and the measure as value:

and the result is this which was the expected:

Now I need to add some formatting using background color, font color, or icons, but the problem is the formatting does not take the whole result, but only one, and I suppose that is because the measure throws one result listed as different rows.

Is there a way to make this possible? I tried creating another measure and applying the format but did not work. Any ideas?

 

Thank you!!

 

 

 

 

2 Replies

    • mcantos's avatar
      mcantos
      Helper II

      Oh yeah, sorry I forgot the most important!! :S

       

      The formatting should be applied based on a different file in the same table Opportunities "owner-email" but not included in the measure I'm displaying as values: 

       

       

      For instance

      if owner-email="antoine" font color: Pink

      if owner-email="zaks" font color: Red

      if owner-email="xavier" font color: Blue

       

      Thanks!