Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dax command for conditional highlighting

Hi All,   I've been following along the Guy in a Cube video to set up conditional highlighting, and I've run into a problem with my dax code:   highlighting = var _Source = Values (Highlight...
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    You are missing the RETURN part, necessary when you use variables:

    highlighting =
VAR _Source =
    VALUES ( Highlight[Source] )
VAR _tohighlight =
    SELECTEDVALUE ( 'Trend_data'[Source] )
VAR _Colour =
    VALUES ( Highlight[HTML_Colour] )
VAR _filtered =
    ISFILTERED ( Highlight[Source] )
VAR _result =
    SWITCH (
        TRUE,
        NOT ( _filtered ), "#5BAF8D",
        _tohighlight IN _Source
            && _filtered, "#5BAF8D",
        _Colour
    )
RETURN
    _result

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

AlB's avatar
AlB
Community Champion
5 years ago

Hi Anonymous 

You are missing the RETURN part, necessary when you use variables:

highlighting =
VAR _Source =
    VALUES ( Highlight[Source] )
VAR _tohighlight =
    SELECTEDVALUE ( 'Trend_data'[Source] )
VAR _Colour =
    VALUES ( Highlight[HTML_Colour] )
VAR _filtered =
    ISFILTERED ( Highlight[Source] )
VAR _result =
    SWITCH (
        TRUE,
        NOT ( _filtered ), "#5BAF8D",
        _tohighlight IN _Source
            && _filtered, "#5BAF8D",
        _Colour
    )
RETURN
    _result

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ah!! I knew it would be something simple. Worked like a charm, thanks so much!!