Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Chua89
New Member

How to create cumulative measure for histogram and bell curve?

Hi I am really new to this so any help is appreciated..

I am trying to do a histogram and bell curve for a number of serial numbers that is delivered within a given timeframe e.g 30 days, 60 days and so on, and i also have a column where i group them into bins (although not sure how this can help)..

 

The resultant histogram chart should show 10 serial numbers delivered within 30days, add on another 10 serial numbers delivered from 31th-60th days so it should show 20 serial numbers (10+10) delivered within 60 days and so on...

 

When i plot my X axis, the result are by days category and not cumulative. Should i create a measure?

Chua89_0-1693316121477.png

 

4 REPLIES 4
asitm
Helper III
Helper III

Hi Chua89

 

If you are open to using a custom visual, you can plot cumulative histograms easily. Though the bell curve is likely not supported yet.

For instance, this custom visual on Appsource

https://appsource.microsoft.com/en-us/product/power-bi-visuals/histogramstd

 

asitm_0-1695896807621.png

 



Cheers!

Asit M

asitm
Helper III
Helper III

Hi Chua89

 

A custom visual can take care of this problem and show cumulative columns. Although the bell curve would be an issue since I don't see any custom visual with a bell curve.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/yavdaanalyticspvtltd1628223732998.his...

 

asitm_0-1695888020377.png

 

 

Regards,

Asit M

MarkLaf
Solution Sage
Solution Sage

I think you can get what you want with Bins in your X-Axis and the following measure in your Y-Axis:

 

Bin Count Cumulative = 
VAR _currentBin = MAX( 'Table'[Bins] )
RETURN
CALCULATE( 
    COUNTROWS( 'Table' ), 
    'Table'[Bins] <= _currentBin 
)

 

You can then get the below with a few formatting tweaks: 1) sort axis by Bins and Ascending, 2) change X-Axis type from continuous to categorical.

 

MarkLaf_0-1693320130354.png

 

Greg_Deckler
Super User
Super User

@Chua89 Sounds like a running total. 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors