TopN + Others based on selected categories from filter feature
Hello, fellow PoweBI enthusiast, I have a question that I'm hoping someone could help me with. I have a table containing credit categories (all is "Total Kredit"), subcategories (sub_kategori), dates, and bu. The "bu" column represents the value amount of credit for each subcategory and date. Now, I'm attempting to create a pie chart that can be dynamically filtered by date, specifically focusing on quarters and years. Additionally, users should be able to filter the subcategories to determine the quantity and specific subcategories they wish to display. With this in mind, my goal is to present only the chosen subcategories for each date based on their bu values. For the categories that users have not selected, I intend to group them under the label "Others." The chart example (on Excel): Is that possible to do? I've watched several tutorials on YouTube and looked through the Power BI community, but the solutions I found don't quite fit my specific problem. Any assistance would be greatly appreciated. Thank you in advance!
Top N plus others
I have a stacked 100% bar chart with "period" on the Y-axis, a simple measure with the sum of values on the X-axis, and "Plan" in the legend. My challenge is: I need to create a chart that shows the top 5 plans, while the remaining plans should be classified as "Others". The table has other fields, and in the example I posted, the group field is used as a filter in my report. Therefore, the classification of the top 5 plans + others needs to be dynamic based on the filter applied by the user on the dashboard. Does anyone have a suggestion for a measure or any other solution for this scenario? Thank you in advance. Arquivo pbix
