Background color

[clem312]

Is it possible to have same background color for 2 measures in a matrix ?

[Fowmy]

@clem312 

Not sure what exactly is required but you should be able to do it with conditional formatting : 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#:~:tex....

[clem312]

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 · Accepted solution]

@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 file

CF = 

SWITCH(
    SELECTEDVALUE(financials[Country]),
    "Canada", "Yellow",
    "France", "Blue",
    "Mexico", "Pink",
    "Germany", "Green"
    )

[clem312]

Hi @Fowmy 

It works fine for the categories. Any idea for the measure that goes with it ?

Kind regards

Clement

[Fowmy]

@clem312 

It doesn't matter which measure is used, you can modify the code for your category and apply.

[clem312]

@Fowmy 

Because in your file, the selection is mage with the Country on the line but in my matrix on line I have an increasing serie (1, 2, 3, 4, 5) so I can present by descending ordering the favorite topics for each brand. 

Like this :