Bucketize % for Graph

[beccar_13]

Hello,

I have a very big data set and am trying to bucketize the amounts into 5% increments on the X-axis of a graph. Can someone please tell me how I would go about doing this?

[Anonymous · Accepted solution]

HI @beccar_13,

For your requirement, you can add a calculated column check amount range to add range tag on it, then use this calculate column as the x-axis and put summary amount to value field.

Reference:

SWITCH statement in DAX using a "between this value and this value" as a filter?

Regards,

Xiaoxin Sheng