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
lbendlin's avatar
lbendlin
Super User
4 years ago

Please provide sample data as a table, not as a screenshot. How does the actual source data look like, pre-pivot?

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Something like this? Which is based on your provided sample data

     

     

    The bad news is that if you want to use the standard matrix visual then this can only be done manually. Colors cannot be changed based on filter choice.   If this is important to you please consider raising it at https://ideas.powerbi.com

    • 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?