Forum Discussion

tmullady's avatar
tmullady
Regular Visitor
10 years ago
Solved

date paramaters

Is there any way to set paramaters in powerbi?  I would like the users to control date ranges for the query results.       Select* from .....   WHERE [DATE] >= (@BegDate) AND [DATE] <= (@EndDat...
  • maracles's avatar
    10 years ago

    It is difficult to exactly what would fit your solution best but a couple of options come to mind. With both of these options you will need to pin a 'Live Page' to your dashboard rather than simply pin individual charts. Live Pages make the filter tools accessible to the user.

    1. Custom Timeline Visualisation.

    https://app.powerbi.com/visuals/

    The Timeline visualisation at the link above allows users to select a specific timerange and can be set to Years, Quarters, Months or Days

    2. Slicer Visualisation

    The slicer visualisation comes as standard with Power BI. Simply create slicers for Year, Quarter or Month. Day may be a little too unfriendly to use depending on your time range. The user can then select the combination of Years, Months that suit them.

    This is not as useful for linear rangers across multiple years, option 1 is better for that.