cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karlagb20
Helper II
Helper II

Background color for a row table/matrix

Hi,

 

I would like to add a background color for a row. Conditional formatting only works for columns.

 

I would like to add a color for the whole GLOBAL row only. Please help

It should look like this (global row all one color)It should look like this (global row all one color)I'm using alternating rows but not what I wantI'm using alternating rows but not what I want

 

 

1 ACCEPTED SOLUTION
MariaP
Solution Supplier
Solution Supplier

Hi @karlagb20 ,

 

You can create a measure and use the new 'Conditional Formating' option where you select formatting by

'Field Value' and in this you choose the measure shown below.

You do this for every column.

 

COLOUR GLOBAL PROJECT ROW = 

IF  (HASONEVALUE(Projects[Project])
    ,IF( FIRSTNONBLANK('Projects'[Project] , 0) = "GLOBAL"
        ,"lightgreen"
        ,"white"
    )
    ,BLANK()
)

Conditional Formatting- Select the measure here.Conditional Formatting- Select the measure here.Apply to every column, works for matrix and tableApply to every column, works for matrix and table

SAMPLE PBIX

 

Maria

View solution in original post

1 REPLY 1
MariaP
Solution Supplier
Solution Supplier

Hi @karlagb20 ,

 

You can create a measure and use the new 'Conditional Formating' option where you select formatting by

'Field Value' and in this you choose the measure shown below.

You do this for every column.

 

COLOUR GLOBAL PROJECT ROW = 

IF  (HASONEVALUE(Projects[Project])
    ,IF( FIRSTNONBLANK('Projects'[Project] , 0) = "GLOBAL"
        ,"lightgreen"
        ,"white"
    )
    ,BLANK()
)

Conditional Formatting- Select the measure here.Conditional Formatting- Select the measure here.Apply to every column, works for matrix and tableApply to every column, works for matrix and table

SAMPLE PBIX

 

Maria

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors