Matrix Color coding for rows

[Anonymous]

I am using a matrix to show 2 measures based on values.  The stakeholders want Growth to be green and Foundational to be blue. This is no conditional formatting in to allow this so is there a dax measure or something I can do as a work around.

[v-lionel-msft]

Hi @Anonymous ,

The current version(2.86.902.0 64-bit (October 2020)) really can not set different types of data bars to different colors.

Try @Fowmy ‘s solution or try to find a custom viusal in appsource .

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Anonymous 

I don't think it is possible but you can apply both Data Bar and Background C-Formatting. Under Background CF, apply the below measure to highlight in Green and Blue

CF = 
IF( SELECTEDVALUE(Sales[Category]) = "Accessories", "Light Green" , IF( SELECTEDVALUE(Sales[Category]) = "Bikes", "Light Blue"))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

This is a table you used - this doesn't work for Matrix.

[Anonymous]

Hi @Anonymous - I havnt tried this but can you try something like this:

https://community.powerbi.com/t5/Desktop/Conditional-Format-for-metrics/td-p/1000572

Hope this give you some pointers

Cheers,

-Namish B