Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
betelgeutsen
Frequent Visitor

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.

betelgeutsen_0-1693275481329.png

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):

betelgeutsen_1-1693275768774.png

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!

0 REPLIES 0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Solution Authors