Dynamic Filter values

[Anonymous]

I have a table with single column that I have dynamically bind to M query parameter.

Column1

now-1d

now-2d

I want to filter the values based on column1 but i want to show value as Last 1day, Last 2 day on filter visual.

Suggest a solution if possible?

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a measure as below to get it, please find the details in the attachment.

Measure = 
VAR _selday =
    SELECTEDVALUE ( 'Table'[Column1] )
VAR _a =
    IFERROR ( SEARCH ( "-", _selday ), 0 )
RETURN
    CONCATENATE (
        "Last ",
        CONCATENATE ( MID ( _selday, _a + 1, LEN ( _selday ) - _a - 1 ), " day(s)" )
    )

Best Regards