Forum Discussion
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 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.
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.
2 Replies
- Ashish_Mathur
Super User
Hi,
Can't the RANKX measure be filtered by "Less then equal to" 10?
v-xicaiCommunity Support
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.
