Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I've a table listpuce (product)
epc0(subproduc)| categorie(product)
I calculate the frequency of each subprodduct in the fact table
I'd like to do a chart like that
This chart is based in the table hilighted which represents freqency already calculated by product
How to it please? Here's the pbix file https://1drv.ms/u/s!Amd7BXzYs7AVlXPjuP0CfblYyc5K?e=1b9DUX
@Anonymous ,
i think you are looking for bucketing
Bucket/Segment code
measure
Measure = [Frequency Measure]
new Table
bucket = Generateseries(1,100,1)
new Measure
Countx(filter(Values(Table[user]), [Measure ] = max(bucket[Value])), [User])
refer
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Power bi New Feature Datamarts - https://youtu.be/8tskWsJTEpg
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 57 | |
| 42 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 113 | |
| 108 | |
| 38 | |
| 35 | |
| 26 |