Forum Discussion
Background color
Is it possible to have same background color for 2 measures in a matrix ?
clem312
You can still use conditional formatting, check the following example. I create a measure to evaluate and apply CF on the background of the sales value measure. I also attached the fileCF = SWITCH( SELECTEDVALUE(financials[Country]), "Canada", "Yellow", "France", "Blue", "Mexico", "Pink", "Germany", "Green" )
6 Replies
- Fowmy
Super User
Not sure what exactly is required but you should be able to do it with conditional formatting :
- clem312
Resolver I
Hi Fowmy,
Not sure because the conditional formatting wants to change color when a measure reach a defined level.
I want to apply a different background color for each categorie in the matrix so you can easily see for each brand the rank of the categorie.
"Vehicle handling" should be blue"Mechanical performance", yellow
etc.
- Fowmy
Super User
clem312
You can still use conditional formatting, check the following example. I create a measure to evaluate and apply CF on the background of the sales value measure. I also attached the fileCF = SWITCH( SELECTEDVALUE(financials[Country]), "Canada", "Yellow", "France", "Blue", "Mexico", "Pink", "Germany", "Green" )