Forum Discussion
Matrix color formatting based on Column
see attached.
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!
Please provide sample data as a table, not as a screenshot. How does the actual source data look like, pre-pivot?
Hi - Thanks for helping me here, Please find the attached and let me know if any issues with the file.
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?