Forum Discussion
Parameter/Bind variables based on Date Calendar Input
The requirement is to restrict the direct query table rows based on Start and End Date calendar inputs as it is a huge transaction table.
Created 2 Calendar tables using DAX :
Start Date - Calendar(date(2012,1,1),TODAY ())
End Date - Calendar(date(2012,1,1),TODAY ())
Bounded to variables
StartDt
Enddt respectively.
However, the users need the flexibility to select the range using Calendar Date picker slicer. Calendar option is disabled for the columns bound to parameters.
I also tried to create a date table Range that will be used for selecting the range.
I created another table that only holds MIN and MAX dates
CALENDAR( MIN(Range[Date]), MAX(Range[Date]))
but MIN and MAX values are showing the range based on all records instead of selected slicer date range.
Is it possible to create columns (not measure as it cannot be linked with variable) that holds min and max date that can be used to initialize a variable?
6 Replies
Hi Anonymous
It seems you are using the Dynamic M query parameter feature. Please refer to the following document to check if your settings have hit one or multiple limitations or unsupported scenarios when using this feature.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
At present it seems your table names have hit below limitation:
- Table names can't contain spaces or special characters.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Hi Anonymous
I'm afraid this is not supported as it would hit another limitation:
- A single parameter can't be bound to multiple fields nor vice-versa.
In a date slicer, it only has one date field, which cannot be bound to two paramters.
Best regards,
Jing
Hi , Did you ever find out the solution for this. I am stuck on it
