Forum Discussion
Dynamic TopN reports in Power BI
Microsoft Employeehttps://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/#topN
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.
- dkay84_PowerBIGot it. Thanks for sharing I will definitely use this
- 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.
