Creating histogram using measure and dimension from data warehouse

Hi I use one dimension and one measure to create the simple table, then change it to a clustered column chart. It shows the values along the x-axis as columns. However, rather than just have columns of individual values, we would like to have a proper histogram with ranges and frequencies. I have read that I can create groups and buckets etc and do it that way, but our powerbi setup for some reason wont allow us to create groups.

Do I need to export the data from the table/graph to a new powerbi file that does allow groups to be created? You can add in histogram visuals from marketplace, but have tried a few and they seem a bit flaky.

We would be grateful if there is a way to code up a histogram via DAX if it can be done via maybe custom measures? but am not sure how it would be done.

Thanks in advance.