Forum Discussion

techhelp's avatar
techhelp
New Member
9 months ago
Solved

Conditional formatting rows based on blank values in the grand total column with matrix visuals

I have a matrix visual and I turned on the grand total column setting. I want to create a conditional formatting rule that will highlight all rows where the grand total column value is blank. 
Need Help
Tips and Tricks
cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
9 months ago

1) Assume this setup

  • Matrix Rows: e.g. Dim[RowName]

  • Matrix Columns: e.g. Dim[Month]

  • Matrix Values: [Your Measure]

  • Column Grand Total is ON

 

2) Create a helper measure to detect “blank grand total”

Is Blank Grand Total =
VAR GrandTotalValue =
    CALCULATE (
        [Your Measure],
        REMOVEFILTERS ( 'Dim'[RpwName] )
    )
RETURN
IF ( ISBLANK ( GrandTotalValue ), 1, 0 )
 
3) Create a color (or flag) measure
Row Highlight Color =
IF ( [Is Blank Grand Total] = 1, "#FFF2CC", BLANK() )

 

4) Apply conditional formatting

  1. Select the Matrix

  2. Values → Conditional formatting

  3. Choose:

    • Background color (or Font color)

  4. Format by: Field value

  5. Based on field: Row Highlight Color