Stack Bar Chart not allowing me to Filter To N

[Anonymous]

Hi everyone,

i have a simple Bar Chart that uses a Text and a Sum of a Number value. I wnat to filter down the top 5 values but it doesn't seem to be available in the drop-down.

Im open to any suggestion 🙂
Thanks in advance

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

To create a measure as below.

Measure = 
VAR ranksum =
    RANKX ( ALLSELECTED ( Table1[cate] ), CALCULATE ( SUM ( Table1[value] ) ) )
RETURN
    IF ( ranksum <= 5, CALCULATE ( SUM ( Table1[value] ) ), BLANK () )

For more details, please check the pbix as attached.

Regards,

Frank

[Anonymous]

RankX work only once it gives rank as a static one time only ,ranks will not work if user applies any filter over data.rankx always give rank for whole table.

[v-frfei-msft]

Hi @Anonymous,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank