TopN + Others Pie Chart filtered by Date (Quarter and Year)
Hello fellow PowerBI enthusiasts, I have a question that I'm hoping someone could help me with. I have a table containing city codes (id_kota), credit categories (jenis_kredit), dates, and nominal values. The nominal values represent the amount of credit for each city, credit category, and date. Now, I'm trying to create a pie chart that can be filtered by date, specifically by quarter and year. The city codes consist of 39 different codes, which makes it quite challenging if I want to display all of them on the pie chart. Therefore, what I want to achieve is to show only the Top 5 city codes for each date based on the nominal values. For the remaining city codes, I'd like to group them as "Others." Additionally, it's important to have the ability to filter the chart based on the date. The pie chart example (I made it on Excel): 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!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!
