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

Posted by Micro Bot


01 Dec, 2024

Updated at 13 Dec, 2024

Creating histogram using measure and dimension from data warehouse

Hi

 

I use one dimension and one measure to create the simple 2 column table, then change it to a clustered column chart by choosing "clustered column chart" from Visualisations area.  The chart shows the individual Measure values along the x-axis as columns with the dimension as the Y axis.

 

However, rather than just have columns of individual values, we would like to condense down the data into a 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.  So to work around that issue, do I need to export the data from the table/graph to a new separate powerbi file that will allow groups to be created? ( or maybe just export to excel and do histogram there? )

 

I have also tried a couple of histogram visuals from marketplace, but they seem a bit flaky.

 

We would be grateful to know who to code up a solution of a histogram via DAX, maybe it can be done via maybe custom measures drawing data from the original table?  but am not sure how it would be done?

 

Thanks in advance.