This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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?
Solved! Go to 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.
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.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 25 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 65 | |
| 41 | |
| 28 | |
| 22 | |
| 22 |