Cannot Convert value of type Text to type Integer: Creating a Slicer Dropdown

[reportuser]

I have a column of Total Duration in seconds and I am trying to create a column called, "Label" which I want to turn into a Dropdown Slicer. I get the error code of, "Cannot conver value 'Less than 300" of type Text to type Integer

Total Duration DropDown = 
SWITCH(
    TRUE(),
    [Total Duration] <= 300, "Less than 300",
    [Total Duration] <= 400, "Less than 400",
    [Total Duration] <= 500, "Less than 500"
)

Total Duration	Label
99	Less than 100 seconds
7	Less than 100 seconds
523	Less than 600 seconds
388	Less than 400 seconds

[amitchandak · Accepted solution]

@reportuser , This code seems fine, hope Total Duration is a column and number type

Can you a sample pbix after removing sensitive data.

[reportuser]

@amitchandak, The label is a column and it was whole number which caused the error. Once I changed the Label Column to Data Type, "Text" the formula worked.

Your question actually provided the solution. Thank you 🙂