Create dynamic groups/categories, to be used as legends in a visual, based on date range slicer

[rashidanwar]

Hi All

I have a table containing 3 columns. trip_date, trip_id and country_name.
I want to create a column chart showing trip month on x-axis and count of trip_id (number of trips) on y-axis.
I have a trip date slicer at the top.

Now if a country has count of trips less than 3 for the selected date range then it shoud be dynamically categorised/grouped to   
"Other" else it shoud be under the country_name. 

For example 
trip_date      trip_id              country_name
1/1/2023      1                      USA
1/2/2023      2                      USA
1/3/2023      3                      USA
1/4/2023      4                      Canada
1/5/2023      5                      Canada
1/6/2023      6                      Canada
1/7/2023      7                      Canada
1/3/2023      8                      Brazil
1/4/2023      9                      Brazil
1/10/2023    10                    Brazil

Output
=> If I select the date range from 1/1/2023 to 1/5/2023 then Brazil and Canada will be grouped under "Others" becasue they have less then 3 trip counts for the selected date range.
=> If I select the date range from 1/3/2023 to 1/8/2023 then USA and Brazil will be grouped under "Others" becasue they have less then 3 trip counts for the selected date range. 

I would appreciate any help in this regards. 

Best Regards
Rashid Anwar

[amitchandak]

@rashidanwar , if think you need a very similar solution, the filter is not on rank measure but on sum of qty measure

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE