Matrix color formatting based on Column

[pitcraj]

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 FY2015 - we would want to color in the values 2012/2013/2014 (light blue) and the other rows with data a different color (Say Green) and also if any value (<0) then Red.
Then for the FY column FY2016 - we would want to color in the values for 2013/2014/2015 (light blue) and the other rows with data a different color (Say Green) and also if any value (<0) then Red.
The same logic would be mimic for each additional year. The expected result should be as in the attached. Please let me know if any additional information needed. I was using DAX functions Selectedvalue and Switch, but I haven't got any success.
The logic should be like this : example - If selectedvalue is FY2015 then the values of (2012,2013,2014) should be in Blue and if any value less than zero (<0) then should be in Red otherwise say Green.
Same logic should go for the next row - If selectedvalue is FY2016 then the values of (2013,2014,2015) should be in Blue and if any value less than zero (<0) then should be in Red otherwise say Green. Same logic should go with each additional year.

Is this possible? Any help on this is much appreciated!

[pitcraj]

Hi - thanks for coming back, much appreciated !

Just to simplyfy - I have attached the simple data table and the matrix in the screenshot.

And the desired output has to be like below:
-When FY is FY2015 then the Row values of 2012,2013,2014 has to pick Blue color Font and the rest has to be green (2015,2016,2017,2018), also one other if any value in that row is negative that has to pick color Red,

-When FY is FY2016 then the Row values of 2013,2014,2015 has to pick Blue color Font and the rest has to be green (2012,2017,2018) also one other if any value in that row is negative that has to pick color Red,

Same logic has to continue for FY2017, FY2018

Please let me know if you need any additional information ! thanks for helping out here!

[lbendlin]

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

[pitcraj]

Hi - Thanks for helping me here, Please find the attached and let me know if any issues with the file.

https://docs.google.com/spreadsheets/d/155Y1bdVVlvyPg9t5fYXiig5qRu7Q5gXB/edit?usp=sharing&ouid=10359... 

[lbendlin]

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]

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]

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]

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.

[lbendlin · Accepted solution]

see attached.

[pitcraj]

Thank you, I can take it from here!

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.