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

Hi ArchStanton ,

Thanks for reaching out to the Microsoft fabric community forum.

This is expected behavior in Power BI and works as designed. A matrix visual and a tooltip page are evaluated under different filter contexts. The matrix evaluates the measure across all visible rows, allowing Min and Max logic to compare values across the entire set of categories. In contrast, a tooltip page is evaluated only for the specific data point being hovered over, so the filter context contains just that value.

 

Since Min and Max calculations need multiple rows to compare, the measure returns a blank result in this context, which Power BI displays as two dashes in a card visual. This isn't a syntax issue or a problem with the measure, but rather how tooltip evaluation functions. To make Min or Max logic work the same way in a tooltip, you need to expand the filter context within the measure to include all relevant rows.


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

 

Best Regards,
Tejaswi.
Community Support






ArchStanton's avatar
ArchStanton
Power Participant
6 months ago

Thanks for this, I tried opening the pbix but had errors - it looks like I'm back using a November version of PowerBI (I had a new work laptop recently). Once IT update me I'll have a look at what you attached and get back to you.

 

 

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

    Hi ArchStanton ,

     

    Understood, that makes sense considering the laptop change.

    Once IT has completed the Power BI update and you’re able to access the PBIX file, please let me know if you have any questions. In the meantime, if anything else comes up, please feel free to keep me informed.

    Best regards,
    Tejaswi.

    • ArchStanton's avatar
      ArchStanton
      Power Participant
      6 months ago

      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.