Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Hi @S1S0,
Maybe you need a measure like this.
ranks = RANKX ( ALL ( 'DimCustomer'[CustomerLabel] ), CALCULATE ( SUM ( FactSales[SalesQuantity] ) ) )
Best Regards,
Dale
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
Hi @S1S0,
Maybe you need a measure like this.
ranks = RANKX ( ALL ( 'DimCustomer'[CustomerLabel] ), CALCULATE ( SUM ( FactSales[SalesQuantity] ) ) )
Best Regards,
Dale