Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Show top 10 Sales percent differences In Trend Chart or Sparkline

Can someone direct me to how I can create either a table with Location Codes and show only the top 10 Locations with YOY Sales Percent changes OR a Trend Line that has all 10 Locations in it?   My ...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You can create rank column like DAX below.

     

    Rank= RANKX(FILTER(Table1 ,Table1 [Location]=EARLIER(Table1 [Location])),Table1 [Sales],, Asc, Dense)

     

    Then create a measure named Filter1, then put measure Filter1 in the Visual Level Filter of goal visual, and setting the Filter1 as "is not blank".

     

    Filter1= IF(MAX(Table1[Rank])<=10, 1, BLANK())

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

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

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

You can create rank column like DAX below.

 

Rank= RANKX(FILTER(Table1 ,Table1 [Location]=EARLIER(Table1 [Location])),Table1 [Sales],, Asc, Dense)

 

Then create a measure named Filter1, then put measure Filter1 in the Visual Level Filter of goal visual, and setting the Filter1 as "is not blank".

 

Filter1= IF(MAX(Table1[Rank])<=10, 1, BLANK())

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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