topic Re: Dynamic input for filters in Developer

Dynamic input for filters

tbrown33 — Fri, 03 Jun 2022 15:49:33 GMT

Does power bi have the ability to build something like an input box where a user can enter a number and filtering is done according to that number.

for example the ability to show sales and quantity sold over a period of time and the user can decide if they want to see it by the past 7 days, 45 days, 180 days. Whichever they would prefer to see.

Re: Dynamic input for filters

lbendlin — Mon, 06 Jun 2022 01:27:28 GMT

That is standard functionality in the filter pane. All you need to do (in the options) is to allow report users to change filter types.

Re: Dynamic input for filters

Anonymous — Mon, 06 Jun 2022 09:38:56 GMT

Hi @tbrown33 ,

I suggest you to use what if parameter to create a slicer.

For reference: Create and use what-if parameters to visualize variables in Power BI Desktop

In my sample I create a 'Past Days' parameter from 1 to 200 and Increment is 1. My data table contains quantities from 2021/01/01 to today. In my example, for ease of calculation, the daily quantity is 1.

Past N days Quantity = VAR _INPUT_DAYS = SELECTEDVALUE ( 'Past Days'[Past Days] ) VAR _QUANTITY = CALCULATE ( SUM ( 'Table'[Quantity] ), FILTER ( 'Table', 'Table'[Date] < TODAY () && 'Table'[Date] >= TODAY () - _INPUT_DAYS ) ) RETURN _QUANTITY

Result is as below.

Past 7 days:

Past 180 days:

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Dynamic input for filters

tbrown33 — Mon, 06 Jun 2022 14:33:38 GMT

Thanks, someone showed me the relative date option within the slicer. This will be the option my users would enjoy using.