Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
beccar_13
New Member

Bucketize % for Graph

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?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
Top Kudoed Authors