Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would like to show in the table only Top 10 Departments with the Total Sales exceeded the Forecast (Top 10 performers for period - dynamicly selected) and have a possibility to drill down the results to Sub-departments and split it via Months/Weeks with the correct Sub-Totals and Totals.
Applying simple Visual filters (for top 10 Departments by measure Diff = Sum('Sales Data'[Sales value])-Sum('Forecast Data'[Forecast Value]) is not working correctly (I am assuming due to the context). Moreover, I want to show only Top Performers (Diff for Department >=0)
Do you have any hints how to obtain it or links to helpfull videos/articles ?
Thanks in advance,
Karo
Solved! Go to Solution.
Hi @karo ,
See if this helps you:https://blog.enterprisedna.co/find-your-top-3-salespeople-per-region-automatically-in-power-bi-using...
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @karo ,
See if this helps you:https://blog.enterprisedna.co/find-your-top-3-salespeople-per-region-automatically-in-power-bi-using...
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Did not get completely
Refer
https://www.tutorialgateway.org/power-bi-top-10-filters/
@amitchandak Thank you for your answer, however I have tried it and it is not working in every scenario. I also need to apply the condition to show only those Department where the Diff >=0 to not show as Top Performance department with Sale below the Forcast.
Hi @karo ,
Is this problem sloved?
If not, please let me know.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |