Normal Distribution over Percentual Histogram

[PedroNBC]

Hello, I'm building a dashboard using a surgical procedure dataset. Each record has a user, service date, and associated cost. I'd like to visualize the cost distribution using a histogram with a superimposed normal distribution curve. The histogram should show the count of records falling within specific percentage intervals of the total cost (e.g., 0-10%, 10-20%).

My challenge is dynamically updating these intervals and the histogram when applying filters (like date). How can I automatically recalculate the percentage ranges and update the histogram based on the filtered data?

[lbendlin · Accepted solution]

How can I automatically recalculate the percentage ranges and update the histogram based on the filtered data?

This is not something you can do in Power BI.  You need to bring all your buckets and bucket sizes beforehand.

Alternatively, look at Tableau which supports dynamic binning.