Wow, such a detailed breakdown on creating a Dynamic TOPN chart! The step-by-step guide is super helpful for PowerBI users. Can't wait to try this out!
Oh no! Line 3, Argument 3 - Total Sales not available. Is it because [Products] and [Total Sales] are in the same table in my session? It's been hours... I may not be able to use this one...
For that you need a separate dimension table with all products + others row. Then the logic would be same, except, for others, you want to always "show". Plus instead of visualizing the [total sales], you would make a new measure to calculate total sales for the product or add up the rest for others.
Hi Chandoo, recent subscriber here and really love the content! Can you please help me out with this - How do I find the salesperson with the highest variance for each month?
You can use TOPN for that. Assuming you have a variance measure, =topn(1, all(salespersons), [variance], desc) should give you a one row table with the salesperson. Send that to a function like selectedvalue to see the name.
Much easier to do in Excel. You don't even need data model. TAKE(SORT(...), n) will give you a dynamic array of what you need. Just feed it to the chart and done.
Thanks, good solution, but not good if you would like to put additional field in chart "Legend" field (for example Department). It will stop to work (will show all and not TOP N).
Hi chandoo, just need your guidance on one thing I am an finance professional with 3.5 years of experience is data analytics a good course for me or is there any other good corses. Pls suggest
Hi Ankit... There is no easy answer for this. What is good for you depends on many factors. I suggest learning data analysis for a while, try a project or two and see if you find it interesting + challenging. Don't give up at first or tenth hurdle though. Push thru for a while and if you still feel negative about it, then pivot and do something else. All the best. If you want a course recommendation, I suggest joining my Excel or Power BI courses. They are top notch and excellent value for money.
I'm using Version: 2.137.952.0 64-bit (October 2024) and I'm unable to duplicate your results. Customer Table, CustomerName column, Invoice Table, Sales column. Relationship by Customer ID column (many invoices to one customer). Your explanation is really straightforward. My display status column reads all "0" Does anyone have any insights? Something I missed?
This is amazing. I just want to understand how you created that Top 10 products bring to certain % of all our sales. And the amount out of total amount?
I love your voice
You are Amazing 💚
Wow, such a detailed breakdown on creating a Dynamic TOPN chart! The step-by-step guide is super helpful for PowerBI users. Can't wait to try this out!
You're very welcome!
I'm amazed that you bring such concepts and explain it in simplest way. Thank you....
You are welcome :)
it's really helps people who want to grow in power BI. Thanks!
Excellent, you made my power bi learning so easy , thanks a lot.
Really learning a lot from you, thanks!👍
Glad to hear it!
your ideas are amazing, thank you for sharing
Great video Chandoo!!!
Glad you enjoyed it
Finished watching
Oh no! Line 3, Argument 3 - Total Sales not available. Is it because [Products] and [Total Sales] are in the same table in my session? It's been hours... I may not be able to use this one...
How do we add "Others" so that chart shows e.g. Top 5 and adds up rest into "Others"
For that you need a separate dimension table with all products + others row. Then the logic would be same, except, for others, you want to always "show". Plus instead of visualizing the [total sales], you would make a new measure to calculate total sales for the product or add up the rest for others.
@@chandoo_ Thanks very much
Hi Chandoo, recent subscriber here and really love the content! Can you please help me out with this - How do I find the salesperson with the highest variance for each month?
You can use TOPN for that.
Assuming you have a variance measure,
=topn(1, all(salespersons), [variance], desc) should give you a one row table with the salesperson.
Send that to a function like selectedvalue to see the name.
How difficult is this to do in Excel with a data model?
Much easier to do in Excel. You don't even need data model. TAKE(SORT(...), n) will give you a dynamic array of what you need. Just feed it to the chart and done.
@@chandoo_ thank you so much!
Thanks, good solution, but not good if you would like to put additional field in chart "Legend" field (for example Department). It will stop to work (will show all and not TOP N).
Thank you. Read up www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/ to know how to deal with multi-level ranking.
@@chandoo_ Thanks.
Excellent thank you
You are very welcome
Hi chandoo, just need your guidance on one thing I am an finance professional with 3.5 years of experience is data analytics a good course for me or is there any other good corses. Pls suggest
What are you looking to upskill in?
@@indrajaravi6945
Just want to upskill myself in finance field only
Hi Ankit... There is no easy answer for this. What is good for you depends on many factors. I suggest learning data analysis for a while, try a project or two and see if you find it interesting + challenging. Don't give up at first or tenth hurdle though. Push thru for a while and if you still feel negative about it, then pivot and do something else. All the best.
If you want a course recommendation, I suggest joining my Excel or Power BI courses. They are top notch and excellent value for money.
I'm using Version: 2.137.952.0 64-bit (October 2024) and I'm unable to duplicate your results. Customer Table, CustomerName column, Invoice Table, Sales column. Relationship by Customer ID column (many invoices to one customer).
Your explanation is really straightforward. My display status column reads all "0"
Does anyone have any insights? Something I missed?
This is amazing. I just want to understand how you created that Top 10 products bring to certain % of all our sales. And the amount out of total amount?
Thank you. Here are the measures I've used:
Top Products Total = CALCULATE([Total Sales], TOPN([Top Products Value], ALL(Products[Product]), [Total Sales], desc))
top products proportion = [Top Products Total] / [Total Sales]
Nice sir
Dude u should also teach how to create that Dynamic Text Box 😂
Plz chandoo can do u have privte corses data analysis and finance in excel if yes plz ur number whatssap