Forum Discussion

tbrown33's avatar
tbrown33
Regular Visitor
4 years ago
Solved

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.  

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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. 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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. 

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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.

  • tbrown33's avatar
    tbrown33
    Regular Visitor
    4 years ago

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