Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a report, that shows the Top n Sub-Categories and Other by Sales Amount.
For the selection of the Top n i created a table with values from 1 to 10.
Select Top n = {1,2,3,4,5,6,7,8,9,10}
I created another table with the Sub-Categories + Other as follows:
Sub-Category and Other =
UNION(
The calculation for the Top n + Other:
This is the result for top 4 that i get and expected:
Now i want to get the Sales value by year for the top 4 and Other. But when i add the year it changes my filter context and i get the top 4 by year:
This is the result i am trying to achieve is the yearly Sales amount by the top 4 of the total Sales amount:
hi , did you reached to the solution. Actually i am having a same requirement. If yes, please do share the solution.
@akoschinek , refer if this approach can help
Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
https://goodly.co.in/top-n-and-others-power-bi/
Thank you for your response.
I actually used this approach to get the Top N and Others.
What i can't get to work, to split this by year without getting the Top N by year, but the yearly amount of the Overall Top N and Others.
Thank you, i wasn't aware the WINDOW function had been added.
But from what i can see i can get the top N Sub-Categories by year, instead of having the overall top N and then taking these and het their value per year.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |