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
