Forum Discussion
Use Slicer to control Sql variable
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 summa...
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.