Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi folks - referring to the below screen grab, I am struggling with the DAX code necessary to creat custom bin sizes. As you can see, I need bin sizes that are not consistent in size. These bins need to show a count of Opportunity ID numbers that fit within each bin. Each Opportunity ID has multiple revenue values that must be aggregated at the Opportunity ID level. Any Idea how this might be done?
Solved! Go to Solution.
@Frenchtom811 , you need to dynamic segementation using an independent table with bucket and use that in new measures .
refer : https://www.youtube.com/watch?v=CuczXPj0N-k
or
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
@Frenchtom811 , you need to dynamic segementation using an independent table with bucket and use that in new measures .
refer : https://www.youtube.com/watch?v=CuczXPj0N-k
or
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |