bold and background color for certain rows of matrix

[Pikachu-Power]

hello all,

i have a matrix with 20 rows. i want bold and color the background of certain rows... is that passible? Not only cells more the whole row from beginn to end.

thanks.  

[v-yingjl]

Hi @Pikachu-Power ，

As far as I know, currently conditional format is not supported in the rows and column headers in the matrix visual in power bi, Value filed is available, you can try to use table visual as @ PhilipTreacy mentioned to set the format.

In addition, here are some simliar ideas about this feature and you can vote for it to help us improve power bi and make this feature coming sooner:

1. Formatting rows in a Matrix individual 
2. conditional formatting 

You can also create a new idea here to sumbit your idea about this feature.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @Pikachu-Power 

Sorry with a matrix you can't change the BG color of the 'rows' - the leftmost column in this case.  You can do this in a table though.

Yes you can use hex colors, specify them as a string like so

Row Color = 

IF  (HASONEVALUE('Table'[Column1])
    ,IF( FIRSTNONBLANK('Table'[Column1] , 0) = 2
        ,"#fff000"
        ,"#f01843"
    )
    ,BLANK()
)

Regards

Phil

[PhilipTreacy]

Hi @Pikachu-Power 

Download sample PBIX file.

You need some way to identify the row.  based on your sample data I can check for the value 2 in 'Table'[Column1].  So create this measure

Row Color = 

IF  (HASONEVALUE('Table'[Column1])
    ,IF( FIRSTNONBLANK('Table'[Column1] , 0) = 2
        ,"lightgreen"
        ,"white"
    )
    ,BLANK()
)

Then apply formatting to each value

Gives this

Regards

Phil

[Pikachu-Power]

hello philip,

thanks but i was a little bit imprecise. what you did is more easier with conditional formatting and rules.

in your example i would like the 2 in column 1 also lightgreen. thats what i mean with "Not only cells more the whole row from beginn to end"

For your solution: Is it also possible to use here HEX Codes? Or is somewhere an overview of colors that can be used?

[PhilipTreacy]

Hi @Pikachu-Power 

You can't make the font bold but you can chnage the background colour using Conditional Formatting rules.

If you can supply some data (as a fle or copy/paste into here) and an example of what you want I'll see what I can do to help.

Regards

Phil

[Pikachu-Power]

Not nice ☹️ maybe some graphics in the store where possible?

I have a 3x3 matrix

Row1 Row2 Col1

1 A 23

2 B 45

3 C 66

How to color the background of the second row? Conditional formatting is not a problem for the column. but how to color for rows?