Forum Discussion

koorosh's avatar
koorosh
Post Partisan
3 years ago
Solved

Create Slicer

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 dated...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    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's avatar
jdbuchanan71
Super User
3 years ago

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.