Matrix Custom Color

Hi Anonymous,

Currently in PBI matrix and tables it's possible to connect a colour field to the condittional formatting in this way you can define the colour on your database and then return that to the matrix visualization however this will only apply to the data not to the headers of the rows or totals.

You need to do the following:

• Add the following measure to your model:

ColourCode = SWITCH(SELECTEDVALUE(Table1[RGY]);
            "Green";	"#01B8AA";
            "Red";	"#FD625E";
         "Yellow";	"#F2C80F")

• On the matrix select the conditional formatting, background colour
• Format by Field Value:
• Based on field select the measure ColourCode
• Your table is filled with the colours you want.

You can change the color codes by the ones you want you just need to keep the # before the codes.

Check the detail and explanation of this feature in the link.

Regards

MFelix