Conditional Formatting within Tooltip

[ArchStanton]

Hi

I have a measure that shows the Max and Min value in a Matrix - it works no problem.

However, I cannot get this to work as a tooltip - is it even possible?

MinMaxMeasure =
VAR ValuesDisplayed =
    CALCULATETABLE (
        ADDCOLUMNS (
            SUMMARIZE ( 'Cases', 'Cases'[PrimaryTopic2] ),
            "Count", [Primary Topics]
        ),
        ALLSELECTED ()
    )
VAR MinVal =
    MINX ( ValuesDisplayed, [Count] )
VAR MaxVal =
    MAXX ( ValuesDisplayed, [Count] )
VAR CurrentValue = [Primary Topics]
VAR Result =
    SWITCH ( TRUE (), CurrentValue = MinVal, 1, CurrentValue = MaxVal, 2 )
RETURN
    Result

Thanks

[ArchStanton]

Hi, I am using the latest version of PowerBI (2.149.1429.0) so I'm not sure why I'm getting these error messages? I'm based in the UK so maybe there's a delay here?

Anyway, I'm not far from finding a solution to this thanks to the help of another superuser (see thread below). The problem I'm having is that I have NULLs in my data so when counting the Min value it's picking up NULLs up instead of the MinCount.

[DataVitalizer]

Hi @ArchStanton 

You need to force the measure to always consider the full set you want, ignoring the current tooltip row context:

MinMaxMeasureTooltip =
VAR ValuesDisplayed =
CALCULATETABLE (
ADDCOLUMNS (
SUMMARIZE ( 'Cases', 'Cases'[PrimaryTopic2] ),
"Count", [Primary Topics]
),
ALLSELECTED('Cases'[PrimaryTopic2]) // make sure all rows are included
)
VAR MinVal = MINX(ValuesDisplayed, [Count])
VAR MaxVal = MAXX(ValuesDisplayed, [Count])
VAR CurrentValue = SELECTEDVALUE('Cases'[PrimaryTopic2])
VAR Result =
SWITCH(
TRUE(),
CurrentValue = MinVal, "Min",
CurrentValue = MaxVal, "Max",
BLANK()
)
RETURN
Result

Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡

🟩 Let's connect on LinkedIn

[ArchStanton]

I tried your code and got the following error:

[krishnakanth240]

Hi @ArchStanton 

Can you please share the screenshot what exactly you are viewing when you add the above measure into table visual for the tooltip. Can you explain how the output should be.  Thank you!

[ArchStanton]

So the tooltip should show red (Max) and Blue (Min) for the monthly values 
Jan = MIN

Aug Max

As you can see, it works fine in the Matrix but its in the tooltip that I want to be able to see the Max & Min