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 ,
This behavior was happening because when a report tooltip is triggered, the hovered month applies a strong filter context to the measures. As a result, the minimum and maximum values were being evaluated only for that specific month instead of across all visible months.
To address this, the month-level filter was explicitly removed within the calculation while still respecting slicer selections. With this adjustment, the tooltip now correctly shows the current month’s value along with the minimum and maximum across all visible months.
Please refer to the attached PBIX file for the updated implementation.
Best Regards,
Tejaswi
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!