Histogram plot

[Anonymous]

Hi Experts 

I need to plot the followin histogram as show in the image using the sample data do not have a clue on how to do this...

sample 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may first consider creating a new table to cover the range and step.

Table =
GENERATESERIES (
    ROUNDUP ( DIVIDE ( MIN ( 'Sheet1'[Value] ), 100 ), 0 ) * 100,
    ROUNDUP ( DIVIDE ( MAX ( 'Sheet1'[Value] ), 100 ), 0 ) * 100,
    50
)

Then use it as the x-axis and please new a measure like:

Measure = 
VAR _cur = MAX('Table'[Value])
VAR _next = CALCULATE(MIN('Table'[Value]),'Table'[Value]>_cur)
VAR _count = CALCULATE(COUNTROWS('Sheet1'),'Sheet1'[Value]>=_cur && 'Sheet1'[Value] <_next)
RETURN
_count

And use it as y-axis.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

https://www.dropbox.com/s/7lqd16wcbp9nt2o/test_.pbix?dl=0 

[nardcox]

Might be me, but I can't open your link.