Distribution of results base on intervals

[Gulian]

Hello, I would like to create a stacked histogram that would show the distribution of results according to a chosen interval.
What formula should I use to specify my intervals.

Let's say my data is in the Results column.

My intervals are
=0% to <64%
>=64% to <74%
>=74% to 100%

Thank you very much.

[v-xuxinyi-msft · Accepted solution]

Hi, @Gulian 

Firstly, you can create a calculated column as follows.

Column =
SWITCH (
    TRUE (),
    'Table'[result] > 0
        && 'Table'[result] < 0.64, "0-0.64",
    'Table'[result] >= 0.64
        && 'Table'[result] < 0.74, "0.64-0.74",
    'Table'[result] >= 0.74
        && 'Table'[result] <= 1, "0.74-1"
)

Create a slicer using the created column.

Here is the visual I created with my test data, for your reference.

Is this the result you expect?

Best Regards,

Yuliax

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Gulian Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490