Revision history [back]

Dynamic bucketing can be implemented in the matrix visual in Power BI by following these steps:

1. Create a new measure that categorizes the values based on your desired bucket size. For example, if you want to bucket the values into increments of 10, you can use the following DAX formula:

Bucket = ROUNDUP([Value]/10,0)*10

1. Add the new measure to your matrix visual.

2. Click on the measure in the Values section of the Fields pane, and select “Conditional formatting” from the options.

3. Choose “Color scales” as the type of formatting, and then set the minimum and maximum values for your buckets. You can also choose your desired color scheme.

4. Click “OK” to apply the formatting.

Your matrix visual will now display the values in dynamically sized buckets, with the color scale providing visual cues for greater insight.