Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ronaldbalza2023
Continued Contributor
Continued Contributor

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!

1 ACCEPTED SOLUTION
PC2790
Community Champion
Community Champion

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

View solution in original post

2 REPLIES 2
PC2790
Community Champion
Community Champion

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

amitchandak
Super User
Super User

@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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.