I need a slicer that would allow me to select range of values instead of all available values

[rangelferreira]

Hello!
I am new to Power BI and I have looked for a post with this exact theme but I couldn't find it.

I have a collum which has rows with ramdom values such as: 

I would like to have a slicer that gives me the option of selecting ranges of values instead of all possible values.

Example:

Select a range

0 -> 63

64 -> 127

128 -> 255

256 -> 511

512 -> 1023

1024 -> 2047

2048  -> 4095

and so on...

Any idea?

Thanks in advance!

[v-frfei-msft · Accepted solution]

Hi @rangelferreira ，

We can create a calculated column likt that to work on it.

range = 
SWITCH (
    TRUE (),
    'Table'[KPI] <= 63
        && 'Table'[KPI] >= 0, "0->61",
    'Table'[KPI] > 63
        && 'Table'[KPI] <= 127, "64->127",
    'Table'[KPI] > 127
        && 'Table'[KPI] <= 255, "128->255",
    'Table'[KPI] > 255
        && 'Table'[KPI] <= 511, "256->511",
    'Table'[KPI] > 511
        && 'Table'[KPI] <= 1023, "512->1023",
    'Table'[KPI] > 1023
        && 'Table'[KPI] <= 2047, "1024->2047",
    'Table'[KPI] > 2047
        && 'Table'[KPI] <= 4095, "2048->4095",
    'Table'[KPI] > 4095, "..."
)

For more details, please check the pbix as attached.

[rangelferreira]

Thanks @v-frfei-msft that worked perfectly for the purpose!!! 😀

[mwegener]

Hi @rangelferreira ,

look at this.

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[rangelferreira]

Thank you @mwegener for sharing this. It will be useful in the future. However @v-frfei-msft had the solution for the situation I was in.