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!

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

Hi ArchStanton ,


Power BI is picking the wrong 'minimum' month because blank (NULL) values are being treated like the smallest number. The solution is to adjust the measure so it ignores blanks first, then calculates the minimum only from rows that actually contain numbers, and finally returns the month linked to that real minimum. In short, filter out empty values before doing the MIN calculation, so 'no data' doesn’t get mistaken for the lowest data.

Thank you.

ArchStanton's avatar
ArchStanton
Power Participant
6 months ago

Thanks, I'm confused because we already have a Variable called NonBlankValues which I thought would do this?

Anyway, my measure is a simple count:

Primary Topic Count = 
COUNT('Cases'[PrimaryTopic2])

 

I have another measure that I use to to count items in the current month which I've modified to use here but I still get the same issue.

 

ISINSCOPE New Topics = 
IF(
    ISINSCOPE(Date2[Mth]), -- Row Level (month) in scope so normal YTD logic
    TOTALYTD(
        COUNT('Cases'[PrimaryTopic2]),
        'Cases'[Created On]
    ),
    -- Total level (month is not in scope so each visible mth is iterated)
    SUMX(
        VALUES(Date2[Mth]),
        TOTALYTD(
            COUNT('Cases'[PrimaryTopic2]),
            'Cases'[Created On]
        )
    )
)

 

I still get the exact same results as before with MIN appearing in months in the future.
These NULLs are because the months are in the future so they are not INSCOPE?

I'm not sure how to fix this.