Forum Discussion

Kirsten10's avatar
Kirsten10
Microsoft Employee
6 years ago
Solved

Dynamic Column Buckets

Hi!

 

I'm hoping you can help me with creating buckets that can sit in a graph with multiple filters.

 

I have a table with customer names and their spend for each month as well as what country, device type, network, and vertical they spent in. I currently have 2 measures: one ranking all of the customers by their spend and another then organising the ranks into 10 buckets. The measures work with the filters for the variables listed above. I can't put the bucket measure into the x-axis of a graph like I would like so I can see the distribution, so I want to create a calculated column for the buckets that would still work with all of the filters.

 

What would be the best way to go about this?

 

Thanks for your help!

1 Reply