Forum Discussion
Create User Defined Bin Slicer with Parameter
I have some data that looks like this:
| Employee ID | Age (years) |
| 1 | 100 |
| 2 | 1 |
| 3 | 18 |
| 4 | 21 |
| 5 | 65 |
| 6 | 7 |
| 7 | 12 |
| 8 | 18 |
| 9 | 24 |
| 10 | 36 |
I am trying to create a histogram that shows this data, with a slicer that will allow my users to define the size of the bins that are present in the visual.
There is a blog post that many people have pointed to that solves this problem. I am trying to follow this method exactly, but the slicer it creates is not interacting with my visual. Does this method still work after the recent updates to the 'New Parameter' Menu?:
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bins
5 Replies
grantsambornSolution Sage
Hi prattja9
With the new New Parameters menu, select Numeric Range. It works with the link you supplied. (pbix: 2 - Choose SIZE of Bins.pbix)
Let me know if you have any questions.
pbix: prattja9.pbix
Interesting, I got it to work with the sample BI report. Another question, my actual data set has multiple line items for each employee. Is there a way to modify the 15th line in the "Count of Customers in each Band - by size" measure to accomodate that complication?
Got it to work using CALCULATE(DISTINCTCOUNT( instead of CALCULATE(COUTROWS(.
Thanks for your help!
