Replace values on x Axis after certain value with 'others'

[yoop_eyes]

Hello

I have a chart that shows the value of deliveries awaiting an invoice, by the number of days it has been waiting. The majority of the value will be between 0 days and 3 days, then there are a couple of outliers that have been open for 20+ days. I'll only really benefit from seeing 0 to 5 days on the graph, but I'd like anything above 5 days to be summarised in its own bar as 'Others'. What is the best way to achieve this please (this is my first ever Power BI chart so go easy on me). 

Thanks

David.

[Jayaselvan · Accepted solution]

1. In Dax or Power Query Convert Days(X-Label  in the graph) into text type. 

2. Create a conditional column in power Query based on Days. If Days <= 5, then Replicate Days Column. Else 6+.

3. Now the graph will look as you expected.

If you have any issues in implementing, please share the pbi file. 

If I have answered your query, Please Accept this as Solution. So that other can be benificial too.

If I have helped in getting solutio in some other way, Consider giving the post like. So that it help me to stay motivated.