Create Slicer

[koorosh]

Hi, Please check the attached file (testdays.pbix). I need a slicer on page one including 3 options.
Option1- filter table visual based on dafediff >60.

Option2- filter table visual based on datediff>100.

Option3- filter table visual based on dafediff>900.

I want a slicer like that one in the test.pbix attached.

[jdbuchanan71 · Accepted solution]

You need to add the Min field to the MeasureListTable and make sure it is a number.

The SelectedMeasure should be loooking at the Min column.

SelectedMeasure = SELECTEDVALUE(MeasureListTable[Min])

Then you write the filter measure and apply it as a filter on your table.

Filter Measure = 
VAR _Days = [SelectedMeasure]
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( VALUES ( 'Table'[DifferenceDays] ), 'Table'[DifferenceDays] >= _Days )
    )

I have attached your file with my updates.

[jdbuchanan71]

On the Days Filter table you should also sort the [Days Range] solumn by the [Min] Column so they appear in the correct order.

[jdbuchanan71]

We can add a selection table that has the minimum days in it to use as a filter.  Create a new table with this dax code.

Days Filter = 
DATATABLE (
    "Days Range", STRING,
    "Min", INTEGER,
    {
        { "All", 0 },
        { "> 60 days", 60 },
        { "> 100 days", 100 },
        { "> 900 days", 900 }
    }
)

Then a measure to read the selection

Selected Option = SELECTEDVALUE ( 'Days Filter'[Min], 0 )

Then the mesure that will filter the table.

Filter Measure = 
VAR _Days = [Selected Option]
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( VALUES ( 'Table'[DifferenceDays] ), 'Table'[DifferenceDays] >= _Days )
    )

You can add that measure to the visual, set a filter on the field to [Filter Measure] is not blank.

You can then remove the [Filter Measure] from the table and it will keep the filter.

I have attached my sample file for you to look at.

[koorosh]

Thank you for your reply. I should read it carefully so please give me time.
Meantime could you please check my attached file and let me know which command I should add to the switch command in 'Dynamicmeasure' measure so that it filters the table visual based on the selected vaule?

Thanks in advance.