Forum Discussion

Mumin192's avatar
Mumin192
Helper I
3 years ago
Solved

Highlight the max value in a chart

Hello

I'm trying to highlight the maximum count by age in my data

I used this measure

Max Value =

var allthedatesused = ALLSELECTED(prf[Age])

var themaxvalue = MAXX(allthedatesused, [TotalPRF])

return

IF([TotalPRF] = themaxvalue,"#000000")

 

it worked, but I had to create a table with all age ranges but sorted by range, but when I link the sort to the age table, it doesn't work

 

Max Value2 =

var themaxvalue = MAXX(ALL(age[Age]), [TotalPRF])

return

IF([TotalPRF] = themaxvalue,"#000000")

 

The first chart is using age from the original table, while the 2nd chart is using the ages table

Any idea how to fix the issue with the 2nd chart?

 

Here's a link for the file

https://drive.google.com/file/d/13S9q0S0oWovbeIbM0lwFLfDgsJFPCsz3/view?usp=sharing

 

Thanks

 

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Mumin192 Here is one possible fix, updated PBIX is attached.

    Max Value2 = 
var __table = 
    ADDCOLUMNS(
        SELECTCOLUMNS(ALLSELECTED(age[Age]),"AgeAge",[Age]),
        "__TotalPRF",COUNTROWS(FILTER(ALL('PRF'),'PRF'[Age] = [AgeAge]))
    )
var themaxvalue = MAXX(__table, [__TotalPRF])
return
IF([TotalPRF] = themaxvalue,"#000000")

     

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Mumin192 Here is one possible fix, updated PBIX is attached.

    Max Value2 = 
var __table = 
    ADDCOLUMNS(
        SELECTCOLUMNS(ALLSELECTED(age[Age]),"AgeAge",[Age]),
        "__TotalPRF",COUNTROWS(FILTER(ALL('PRF'),'PRF'[Age] = [AgeAge]))
    )
var themaxvalue = MAXX(__table, [__TotalPRF])
return
IF([TotalPRF] = themaxvalue,"#000000")