Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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
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
User | Count |
---|---|
126 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |