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

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