Power bi - Use Slicer selection in filtering data

Question

I am new to Power bi but i want to use Slicer(user selection) while filter data with comparison by 'Greater Than' instead of equal to.

I have data of devices with LastUpdated date column. and slicer with few list of dates for 15 days gap (calendar would be better but as it is not available yet sticking with dates list)

When user select a date in Slicer i want to filter the data whose Lastupdated Date is greater than equal to selected date. How to achieve this? tried columns,measures..

Any help is appreciated.

Slicer does not support this, you just should use filter pane with advance fitlering — cuongle

alejandro zuleta alejandro zuleta · Accepted Answer · 2016-09-27T01:51:44

I think you can create a measure that links the Date list table and the Device table, even if there is no relationship between them. However the measure must be present in your visualization otherwise the slicer will not affect it.

I've created a measure that calculates the maximum date for those rows which last update date is greater or equal than the slicer selection.

CalculatedLastUpdate =
CALCULATE (
    MAX ( DeviceTable[LastUpdate] ),
    FILTER (
        DeviceTable,
        DeviceTable[LastUpdate] >= MINX ( DateList, DateList[Date] )
    )
)

DateList - a table containing a column [Date] with you date range.
DeviceTable - a table containing device data.

Now you can delete LastUpdate column from your visualization in order to avoid two columns with the same data.

Let me know if it helps.

Power bi - Use Slicer selection in filtering data

2 Answers