topic Re: Dax command for conditional highlighting in DAX Commands and Tips

Dax command for conditional highlighting

Anonymous — Wed, 21 Oct 2020 06:00:50 GMT

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[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)

I'm getting an error which essentially says syntax for ')' and I can't work out where I've gone wrong! Is anything obvious jumping out at anyone?

Re: Dax command for conditional highlighting

AlB — Wed, 21 Oct 2020 07:39:55 GMT

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

Re: Dax command for conditional highlighting

Anonymous — Wed, 21 Oct 2020 08:34:06 GMT

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