Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.

 

Im open to any suggestion :)
Thanks in advance

Need Help

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
      v-frfei-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      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