Forum Discussion
Top 10 Per Month
Hi,
I want to create a stacked column chart that shows the top 10 selling products per month. I entered my date field on the axis, product name on the legend and sales on the values and I filtered to Top 10 for total sales, but it shows me the overal top 10 products from the whole year and the sales of those same 10 products every month. It doesn't show me the top 10 products of each individual month. How can I change it to show me the top 10 products of each individual month? Hope I'm making sense.
3 Replies
mlmagl14 , Just Try to use TOP 10 Measures
CALCULATE([sales],TOPN(10,allselected(Table[Product Name]),[sales] ,DESC),VALUES(Table[Product Name]))
Hi,
Thank you for helping me. Can you explain more how to use this measure? Sorry, I am very new to power bi. Can I use the measure on the stalked column chart? If so, where do I put it under?
Hi, mlmagl14
Your needs can be met, but it needs to be filter by measure using topn function.
Can you share some sample data or file and your desired result? I'm not clear about your data and context it's hard to give specific measures.
Reference: How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Community Support Team _ Janey
