Forum Discussion
Matrix color formatting based on Column
see attached.
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
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?
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?
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.see attached.