Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
7 months ago
Solved

Conditional Formatting within Tooltip

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 ValuesDisp...
Need Help
Show and Tell
  • ArchStanton's avatar
    ArchStanton
    6 months ago

    Hi,

    Thanks for the help with this, its much appreciated.

     

    Unfortunately, this isn't the behaviour I'm looking for as a solution, I need the Max & Min month name to be showing in the tooltip, preferably in its own column, your solution doesn't make it immediately obvious what months out of a possible 12 are the Max and Min.

    I will close this ticket and re-open a new one.

    It maybe the fact that what I'm asking for is not even possible so it will be good to re-issue a new version of this ticket to see if that even possible.

    Once again, thanks for all your help!

danextian's avatar
danextian
Super User
7 months ago

Hi ArchStanton 

Try this pattern and also ensure to use in the visual the same dimensions specified in the measure.

MinMaxMeasure = 
VAR valuesDisplayed =
    ADDCOLUMNS ( SUMMARIZE ( ALLSELECTED ( Data ), Data[Date] ), "count", [Total Transactions] )
VAR MinVal =
    MINX ( valuesDisplayed, [count] )
VAR MaxVal =
    MAXX ( valuesDisplayed, [count] )
VAR Currentvalue = [Total Transactions]
VAR Result =
    SWITCH ( TRUE (), CurrentValue = MinVal, 1, CurrentValue = MaxVal, 2 )
RETURN
    Result

 

 

 

ArchStanton's avatar
ArchStanton
Power Participant
7 months ago

Hi,

 

Unfortunately your code just gives me a 1 but not a 2 - the 1 is alongside missing Primary Topics.

 

 

MinMaxMeasure1 = 
VAR valuesDisplayed =
    ADDCOLUMNS ( SUMMARIZE ( ALLSELECTED ( 'Cases'),'Cases'[Created On]), "count", [Primary Topics] )
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

The problem I have is that not every Primary Topic is populated (I have lots of NULLs), whereas your Date field is continous.

Any ideas?