Custom Slicer on INT value

Anonymous 

Create a New Calculated Table for the Slicer

Custom Slicer Table = 
DATATABLE(
"Range", STRING,
{
{"Number of Days <= 15"},
{"Number of Days >= 15 & Number of Days <= 30"},
{"All Number of Days"}
}
)

Create a Measure for Filtering

Filtered Measure = 
VAR SelectedRange = SELECTEDVALUE('Custom Slicer Table'[Range])
RETURN
SWITCH(
TRUE(),
SelectedRange = "Number of Days <= 15", IF(MAX('Actual Table'[Number of Days]) <= 15, 1, 0),
SelectedRange = "Number of Days >= 15 & Number of Days <= 30", IF(MAX('Actual Table'[Number of Days]) >= 15 && MAX('Actual Table'[Number of Days]) <= 30, 1, 0),
SelectedRange = "All Number of Days", 1,
0
)

Add the Custom Slicer Table to your report and use it as a slicer.
Add the Actual Table to your visuals (e.g., table or chart).
Go to the Filters pane for the visual and apply the Filtered Measure as a filter, setting the value to 1.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn