Show top 10 Sales percent differences In Trend Chart or Sparkline

[Anonymous]

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 Table is something like

Location    Date    Sales

A               1/1/19    100

A                1/1/18    50

Then I would want to see Location A with +50 sales ranked as 1 and then others below that.

This seems like it should be so easy but is proving to be difficult.  

I currently have a RANKX function but PBI doesn't let me filter by it in my views.  Which would have made my life easier.  

[v-xicai · Accepted solution]

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.

[Ashish_Mathur]

Hi,

Can't the RANKX measure be filtered by "Less then equal to" 10?