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!
