Forum Discussion

S1S0's avatar
S1S0
New Member
8 years ago
Solved

TopN Values by Year

Hi, currently I am trying to build a bar chart that shows what the top 5 sellers are for each individual year. The problem is when i use the TopN filter with the bar chart I get the Top 5 sellers for all years and how they have trended through the years. Does anyone know how I would go about making this visual?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi S1S0,

     

    Maybe you need a measure like this.

    ranks =
RANKX (
    ALL ( 'DimCustomer'[CustomerLabel] ),
    CALCULATE ( SUM ( FactSales[SalesQuantity] ) )
)

    Top_N_Values_by_Year

     

    Best Regards,

    Dale

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi S1S0,

     

    Maybe you need a measure like this.

    ranks =
RANKX (
    ALL ( 'DimCustomer'[CustomerLabel] ),
    CALCULATE ( SUM ( FactSales[SalesQuantity] ) )
)

    Top_N_Values_by_Year

     

    Best Regards,

    Dale

  • Memphis28's avatar
    Memphis28
    Frequent Visitor
    2 years ago

    Afternoon

    I appreciate this was answered quite some ago but hopefully someone can help.
    I have given a rank to all my data using the method above however when apply this to a bar chart it doesn't seem to actually remove the values, only hide them.

    So when a specific data entry appears in the top 5 on one year but not the next, it is leaving a space for this reason. Is there anyway to close the gap so it gives me the top 5 reasons for each year clustered together no matter what they are?

     

    Thanks in advance