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

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

Capture.PNGIt should look like this (global row all one color)Capture2.PNGI'm using alternating rows but not what I want

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
MariaP Member
Member

Re: Background color for a row table/matrix

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()
)

ConfitionalFormatOptionForEachColumn.PNGConditional Formatting- Select the measure here.ConditionalFormatUsingMeasure.PNGApply to every column, works for matrix and table

SAMPLE PBIX

 

Maria

View solution in original post

1 REPLY 1
MariaP Member
Member

Re: Background color for a row table/matrix

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()
)

ConfitionalFormatOptionForEachColumn.PNGConditional Formatting- Select the measure here.ConditionalFormatUsingMeasure.PNGApply to every column, works for matrix and table

SAMPLE PBIX

 

Maria

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors