Forum Discussion
DAX Slicer Custom Values
Hi All,
Just wanted to ask on how can I create a custom slicer (number range, ie. 10, 11-50, 51-100, 101-150, 151-200). How can I do it? I have a measure that generates series from 1-200. But how can I group them from 10, 11-50, 51-100, 101-150 etc.,) Thanks!
Hello ronaldbalza2023 ,
You can create a calculated column using logic such as :
RANGE = SWITCH(TRUE(),
AND([Value] < 10,[Value]>0), "1-10",
AND([Value] < 50, [Value]>11), "11-50".......................and so on
Then you cna use it as a slicer and perform the required operations.
i hope it works for you
2 Replies
Hello ronaldbalza2023 ,
You can create a calculated column using logic such as :
RANGE = SWITCH(TRUE(),
AND([Value] < 10,[Value]>0), "1-10",
AND([Value] < 50, [Value]>11), "11-50".......................and so on
Then you cna use it as a slicer and perform the required operations.
i hope it works for you
ronaldbalza2023 , I am assuming custom slicer is an independent table and use that is measure.
refer my video on similar topics - https://www.youtube.com/watch?v=CuczXPj0N-k&feature=youtu.be
