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
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.