Forum Discussion

pitcraj's avatar
pitcraj
Helper I
4 years ago
Solved

Matrix color formatting based on Column

Hi All, I am using the matrix visual with a single field (FY) in Row and multiple Values in Values section. I am looking to get a Font color formatting on it as in attached: For the FY column FY20...
Need Help
pitcraj's avatar
pitcraj
Helper I
4 years ago

Thanks for quick response, I am looking to get the font colors change to Row values not to the Row headers, like if FY (FY2015) selected then the Row value Colors has to change like you did to Row headers, is that possible?

 

lbendlin's avatar
lbendlin
Super User
4 years ago

Manipulating the font color of the cells is much easier to do. However I do not understand your logic rules at all.  You also have no negative values in your sample data.  Can you please explain the rules again and show all scenarios?

  • pitcraj's avatar
    pitcraj
    Helper I
    4 years ago

    Thank you, forget about the negative values, this sample i gave doesn't have negative, sorry for confusion, Now all i need is simply:
    if FY (FY2015) then I need the row values of (2012,2013,2014) to be colored in "Blue" else all other row values in "Green", 

    same way if FY (FY2016) then I need the row values of (2013,2014,2015) to be colored in "Blue" else all other row values in "Green", 
    same logic follow after every FY.

     

      • pitcraj's avatar
        pitcraj
        Helper I
        4 years ago

        Thank you, I can take it from here!