Use Slicer to control Sql variable

[Lily36876]

I have a period sql query to concat and calculate data in system,

now I need to trans it to power bi show dashboard,

but sql query declare StartDate and EndDate,

and this program syntax only summarize period salestotal data,

system has options to specify date period,

means I hope I can use powerbi slicer to give variable(date period) to show matrix,

is it possible to achieve?

OR not slicer,

any tool I can give it data to control variable

[Anonymous]

Hi @Lily36876 ,

You could create a calendar with CALENDAR() function to connect your date period.

Then you could create a slicer with date field or add the date field to the filters, or even create a measure for the visual-level filter.

Reference:

Slicers in Power BI - Power BI | Microsoft Learn

Add a filter to a report in Power BI - Power BI | Microsoft Learn

Types of filters in Power BI reports - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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