Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
6 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!

v-tejrama's avatar
v-tejrama
Community Support
6 months ago

Hello ArchStanton ,

The main issue was that the tooltip was only evaluating the single hovered point instead of the full month range shown in the sparkline. To fix this, I rebuilt the example using a proper Calendar table linked to the cases data by date, and added a fiscal month number (Apr–Mar) so the months sort correctly. The tooltip measures then use ALLSELECTED to look across all months in the sparkline context, and TOPN to determine which month has the highest and lowest values, returning the month names instead of just the numbers.

 

I added the measures to a report tooltip page and linked it to the matrix. Now, when you hover over a row, the tooltip shows the actual months where the sparkline reaches its maximum and minimum, not just the values. Because the logic evaluates over the same month context as the sparkline, it works consistently even within the limited filter context of a tooltip.

 

Please find the attached PBIX and Screenshort file for your reference.



Best Regards,
Tejaswi.
Community Support

 

v-tejrama's avatar
v-tejrama
Community Support
6 months ago

Hi ArchStanton ,

 

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

 

  • v-tejrama's avatar
    v-tejrama
    Community Support
    6 months ago

    Hi ArchStanton ,

     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

    Thank you.

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    6 months ago

    Hi, I've been away and not had a chance to look at your latest advice, I will try and get back to by the end of tomorrow at latest - thanks again for helping!