Group the Bins: Bins + Other

[xariet]

I am uncertain whether a solution exists, but perhaps someone can assist me. I currently possess a bar chart that displays annual income on the x-axis, divided into variable-sized bins regulated by a slicer. My goal is to create a division between annual incomes less than and greater than $200,000. For incomes less than $200,000, I wish to retain the current bin separation displayed in the chart. However, for incomes greater than $200,000, I want to combine all bins into a single bin. While I have succeeded in grouping the bins based on this criterion, I am unable to figure out how to merge the income greater than $200,000 into a single bin; the grouping merely allows for the application of different colors to the bins.

Current chart and desired chart:

[v-shex-msft · Accepted solution]

HI @xariet,

Perhaps you can take a look at the following link about dynamic segmentation if it helps for your scenario:

Dynamic segmentation – DAX Patterns

Regards,

Xiaoxin Sheng