Dynamic Column Buckets

[Kirsten10]

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!

[v-juanli-msft · Accepted solution]

Hi @Kirsten10 

By design, a calculated column would not work with filters in Power BI.

You could refer to this similar thread.

https://community.powerbi.com/t5/Desktop/Create-a-bar-graph-with-measures-as-axis/td-p/455900

If you have any problem, feel free to let me know.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.