Creating custom bin of ranges for negative and positive values

[Anonymous]

Hi, I have a column called "Value" which has values from -30 to +30.

Now I want to create a bar chart where these values will sit on a range of -16 below, -6 to -15, -1 to -5, 0 to 5, 6 to 15, and 16 above.

I tried creating a Conditional column, but power bi cannot handle negative values. Any idea how to fix it?

[Anonymous]

yes, this was the solution I was looking for. Thank you Johncolley.

[johncolley · Accepted solution]

Hi Sunile,

I think Conditional Column is the right approach. Only using dummy data but it appears to be handling the negative values. Please note I also created an second table for the sort order of the grouping.

Is this the result you were after?