Forum Discussion
Conditional Formatting within Tooltip
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!
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
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 ResultThe problem I have is that not every Primary Topic is populated (I have lots of NULLs), whereas your Date field is continous.
Any ideas?
Hi,
I have Blank Primary Topics in my data so the MinValue is picking these up. I've tried to isolate Blanks as zero so I can exclude them from the code, I've done this - is it possible to select the next smalles MinValue?Hello again ArchStanton ,
To address this scenario, it's important to recognize that tooltip visuals operate within a much narrower filter context compared to standard visuals like a matrix. When hovering over a value, the tooltip only considers that specific category, so any logic intended to compare values across categories will not work unless the context is deliberately broadened.
The recommended approach is to use a measure that evaluates all visible categories by applying ALLSELECTED to the category field, then calculating the minimum and maximum from that set while excluding blanks. After creating this measure, add it to a dedicated tooltip page and assign that page to the matrix.
Please find the attached PBIX and Screenshort file for your reference.
Best Regards,
Tejaswi.
Community SupportThanks again for your advice, i really appreciate all of your help.
Unless you say otherwise I don't think its possible to do what I want?
I want the months of the Max and Min markers in the Sparkline to be shown in the tooltip. The sparklines represent the FY Apr - Mar.Your Max & Min tooltip does work, it seems like we're not a million miles from achieving my aim?
