Forum Discussion

Prakash1050's avatar
Prakash1050
Helper III
1 year ago
Solved

Background Color in Matrix rows

Hi All,       I have one matrix visual.  That matrix row have : Table 1 [Details] That matrix column have : Calender[Month_Year_Format] That matrix value have : one measure[Overall_Measure] it re...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Prakash1050 ,
    If you want to automatically determine if a month is legal, you can create two columns on the table

    IsNotBlank = 
IF(
    'Table 2'[Value] <> BLANK(),
    1,
    0
)

    IsTrue = 
CALCULATE(
    SUM('Table 2'[IsNotBlank]),
    ALLEXCEPT(
        'Table 2',
        'Table 2'[Month_Year]
    )
)

    Create a column on the calendar table

    IsExist = 
VAR CurrentMonthYear = 'Calendar'[Calendar]
VAR _isTrue =
IF (
    ISBLANK (
        LOOKUPVALUE (
            'Table 2'[IsTrue],
            'Table 2'[Month_Year], CurrentMonthYear
        )
    ),
    0,
    LOOKUPVALUE (
        'Table 2'[IsTrue],
        'Table 2'[Month_Year], CurrentMonthYear
    )
)
RETURN
IF(
    _isTrue > 0,
    1,
    0
)

    Putting isExist into the visualization filter

    Set is 1 and final output

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     



     

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

Prakash1050 

Update the Highlight Measure

Highlight = 
VAR details = SELECTEDVALUE('Table 1'[Details])
VAR hasValue = NOT(ISBLANK([Overall_Measure]))
RETURN 
IF(details = "XXX" || details = "YYY" || (details = "XXX" || details = "YYY" && NOT HASONEVALUE('Table 1'[Details]) && NOT hasValue), 1, 0)

In the conditional formatting dialog, set the rules:

  • If Highlight equals 1, set the background color to #F0AF87.
  • If Highlight equals 0, set the background color to White.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

Prakash1050's avatar
Prakash1050
Helper III
1 year ago

No, this measure also don't change the background color of the blank values.