Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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    
Need Help
Show and Tell
Tutorial Requests
  • MariaP's avatar
    MariaP
    7 years ago

    Hi Anonymous ,

     

    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.Apply to every column, works for matrix and table

    SAMPLE PBIX

     

    Maria

Noredlac86's avatar
Noredlac86
Icon for Helper I rankHelper I
3 years ago

Hi MariaP 

I was wondering if its possible to change the color for the "ROWS" using a matrix chart. I mean your code works 100% if i use a table, but if i use Matriz, does not work.

I have this:

 

and i want to change the color of the rows (I mean the text in the first column, A) 0-15Days.... etc.

Im using matrix chart. I need that the first row, will be total green, the second one total yellow and go on, but your code just works for values.

Do you know if there is any workaround.?

Ashokrajm's avatar
Ashokrajm
Frequent Visitor
3 years ago

Did you find any soloutions to this?