Creating variable-sized bins in DAX for Power BI

Varsha Panda 0

In Power BI Desktop, how can bins of different sizes be created in one column based on the values from another column using DAX?

For example:

Column X contains three values: A, B, and C.
Column Y has 100 values ranging from 1 to 80 (e.g., 1.02, 3.05, 20.84, 67.42).

The desired bin sizes are as follows: i. For Column A: 1, 2, 3, ... ii. For Column B: 5, 10, 15, ... iii. For Column C: 10, 20, 30, ...

Any guidance on how to achieve this would be appreciated!

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Richard Yung 120 Reputation points

2026-03-09T15:13:25.2533333+00:00
Hi Varsha,

To create variable-sized bins based on another column's logic, you can use the SWITCH function combined with TRUE() in a Calculated Column.

Here is a sample DAX pattern you can adapt to your specific conditions:

Bins =

SWITCH(

TRUE(), 'Table'[Column X] = "A" && 'Table'[Column Y] <= 20, "Group 1", 'Table'[Column X] = "B" && 'Table'[Column Y] <= 50, "Group 2", 'Table'[Column X] = "C", "Group 3", "Ot

her"

)

This approach allows you to define specific logic for each category and their respective numeric ranges flexibly.

Hope this helps!