cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Dynamic input for filters

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.

1 ACCEPTED SOLUTION
Community Support

Hi @tbrown33 ,

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

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.

3 REPLIES 3
Regular Visitor

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

Community Support

Hi @tbrown33 ,

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

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.

Super User

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors