Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

power bi for pretty histograms

I'm doing some work where folks are typically using R and/or Python for creating visuals.  In those environments creating a histogram for any given column of data is as simple as the following: 

    R = hist(mydataframe$somecolumn)

    Python = mydataframe.somecolumn.plot.hist();


My interest is to create the histograms i need to generate in power bi given i find the environment much more approachable when it comes to making the visuals pretty.


The issue i'm finding is that dragging any column onto power bi report surface and changing visual to one of the column [ / histogram ] visual options only presents statistical summarization options in the Value field drop down, e.g. Sum, Count, Median. It doesn't provide a "Don't Summarize" option like you get with X/Y Axis field drop downs in the case of a Scatter chart.  I tried using "Count (Distinct)" which i'd expect should produce the desired histogram / frequency chart result but it did not.


I found some article suggesting i go off into query editor and for every histogram / frequency chart column value i wanted to create a visual for create a new query property of the form "= Table.Group(Source, {"somecolumn"}, {{"count", each Table.RowCount(_), type number}})" which i did and can use that count property to get a histogram / frequency chart view but wierdly i have to select Sum, Average, Min, Max, Median in the Column values drop down summarize options since again there is no "Don't Summarize" option.


So i'm thinking I really must be overlooking something obvious here given creating a histogram / frequency chart for any given column value should be a no brainer in power bi right. Any hints as to what i'm doing wrong?




Super User IV
Super User IV

You could just use an R Visual and use that exact R code pretty much.


Can you post some sample data and maybe an example of what you are trying to accomplish. You do get a Don't Summarize option for certain visuals like Tables, etc. but not for bar/column charts for numeric values. I'm not exactly sure what you are trying to accomplish by using a bar/column chart without some form of aggregation.


Please see this post regarding How to Get Your Question Answered Quickly:


@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors