Forum Discussion
Dynamic TopN reports in Power BI
Because the user can't easily adjust that. You may want to see which stores or items are actually driving the KPI. In addition, you can use it to create the bottom half of the visual I have there which is to see the TopN stores total contributition to the KPI, as well as Percent of total.
The TopN function in Power BI is great for a set-it-and-forget-it report, but not if you want to let the user choose the the 'N' value themselves.
With this report, I also included a slicer that allows them to choose the KPI they want to see (Profit, Returns, Sales). In order to make the TopN part respond in respect to the selected KPI, I went with DAX. I guess what I'm trying to show is how to extend Power BI reports through some clever, yet simple DAX.
Microsoft Employee- Phil_Seamark
Sometimes it's just nice to have a button to press on the screen for the user rather than make them use the dropdowns on the side.
Nice article
- dkay84_PowerBIPlus if this is a published report where the page is pinned to a dashboard then there would be not dropdown filter on the side.
Excellent point. I'm working on some blogs that outline some techniques for the Retail Analysis -Dynamic Measure&TopN Selection. If you take a look at it and see any part that you'd be interested in learning more about, I'd love to hear it so I can write a how-to post.
Also you can go to bipatterns.com for more techniques and user guides.
