cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dhurtubise Member
Member

Stack Bar Chart not allowing me to Filter To N

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.

NotShowing.jpg

 

Im open to any suggestion Smiley Happy
Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Stack Bar Chart not allowing me to Filter To N

Hi @dhurtubise,

 

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 () )

Capture.PNG

For more details, please check the pbix as attached.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Stack Bar Chart not allowing me to Filter To N

Hi @dhurtubise,

 

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 () )

Capture.PNG

For more details, please check the pbix as attached.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Stack Bar Chart not allowing me to Filter To N

Hi @dhurtubise,

 

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


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
anilgavhane21 Regular Visitor
Regular Visitor

Re: Stack Bar Chart not allowing me to Filter To N

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.