• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by Micro Bot


01 Dec, 2024

Updated at 02 Dec, 2024

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.