Pie chart grouping low rank together while the value and ranking may change according to slicer

[Anonymous]

Given a column of parameters, a measure for calculating their values, a measure to dynamically calculate the rank with respect to the values of the parameters and a measure to produce the new parameter names (first 4 the same as parameter and others as others) according to the rank.

A slicer of date is applied, so the values of parameters will change as the result of the filtering, so does the rank.

How to make a pie char, so that the legend will show the first 4's names and an "other", with the filtered sum of values of them?

Measure is not allowed as legend. Is there a round way for this?

[amitchandak]

@Anonymous , Try to use the index function, I have used 1 , you can use 4 or a numeric patameter

Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

Like this but with index

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

[Anonymous]

@amitchandak I went through the two videos, but I am still not sure, how the total value of the others can be calclated out and shown up in the chart?