topic Re: Dax Funktion to mark up Table line in color in DAX Commands and Tips

Dax Funktion to mark up Table line in color

Boni — Mon, 23 Aug 2021 09:01:13 GMT

Dear Community,

is there any dax formular, witch I can Use to mark up the Lines in my table with colors. I specialy need a formular witch mark ups the line when three conditions are completed.
Example:

I whant to markt the line of "line Item A1" in green because both conditions are completed sucsesfull.
It would be much better if there is a Slicer that can display if functions.
That means: when I tell the filter: please mark all lines with a CTR of 0.02% and over 100 impressions in green.

Thanks for helping me out.

Boni

Re: Dax Funktion to mark up Table line in color

selimovd — Mon, 23 Aug 2021 09:14:10 GMT

Hey Boni ,

that should be possible.

You can create 2 what-if parameter, one for the CTR and one for the impressions. The SELECTEDVALUE from these two slicers you can then use in a "formatting measure". You can check if [CTR] and [impressions] are above the selected values and if yes return green, otherwise red. This measure you can then use for all columns as background formatting.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

Re: Dax Funktion to mark up Table line in color

Boni — Wed, 25 Aug 2021 08:40:31 GMT

Hi Denis,

I createtd now the two what if functions. But now I am lost again.
I tried to build an Funktion: = IF ([CTR] <0.2, green, red),
Selectedvalue ('CTR what if parameter')
is this the way you ment?
would be aswome if you could have a quick view on this.
Beste regards

Boni

Re: Dax Funktion to mark up Table line in color

PaulDBrown — Wed, 25 Aug 2021 17:52:04 GMT

any chance you can share a sample PBIX file through Onedrive, Dropbox, Google Drive...?

Re: Dax Funktion to mark up Table line in color

selimovd — Thu, 26 Aug 2021 12:58:51 GMT

Hey Boni ,

more something like this:

Color Measure = VAR vCTRParameter = SELECTEDVALUE( 'CTR what if parameter'[CTR Column] ) VAR vImpressionParameter = SELECTEDVALUE( 'Impression what if parameter'[Impression Column] ) RETURN IF( [CTR] < vCTRParameter && [Impressions] > vImpressionParameter, green, red )

Can you work with this? Otherwise I would be happy if you could share your file or create a demo file and I can implement the approach.

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic