Dax Funktion to mark up Table line in color

[Boni]

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 

[selimovd]

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

[Boni]

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 

[selimovd]

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

[PaulDBrown]

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