Forum Discussion

kilala's avatar
kilala
Icon for Resolver I rankResolver I
8 months ago
Solved

Rank shows all 1

Hi all,   I have a trend bar chart that want to show "Exclude top 5". It will show all months that is ranked 5 and above based on total volume.  This is the DAX I used: Top 5 Vol (Trend) = RANK...
Need Help
Show and Tell
  • danextian's avatar
    danextian
    8 months ago

    Hi kilala 

    Is DIM_TIME_PERIOD_SELECTED[Month_Year] custom sorted by another column? If so, you need to include that in your ALLSELECTED statement as well.

danextian's avatar
danextian
Icon for Super User rankSuper User
8 months ago

Hi kilala 

Is DIM_TIME_PERIOD_SELECTED[Month_Year] custom sorted by another column? If so, you need to include that in your ALLSELECTED statement as well.

  • kilala's avatar
    kilala
    Icon for Resolver I rankResolver I
    8 months ago

    Hi danextian ,

    You are correct! This month_year column are sorted according to startperioddate column. I have included this column as well and it able to sort it correctly now.

     

    Thank you for your reply and i wish your day would go smoothly!