Solved: Bucketize % for Graph

beccar_13 · ‎08-09-2017

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 · ‎08-10-2017

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

View solution in original post

Anonymous · ‎08-10-2017

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