Forum Discussion
User-Maintainable Date Parameter
Hello,
I am currently working on a dashboard where I would like to add a date parameter that the Viewer-User of the dashboard can maintain and therefore change the data he sees. I would like to have this as an alternative to the date filter because of the complexity of the measures.
But in PBI Desktop I only see parameters in number format, in Power Query I have the possibility to create date parameters but I have found no way of giving the user the opportunity to choose a date in the Dashboard. Is there any way to do it?
Hi MiriamLeischner ,
I created some data:
You can create a date table, create a relationship with the table according to the date column, Keep the relationship is Inactive.
Here are the steps you can follow：
1. Create calculated table.
Date2 = CALENDAR(MIN(Data1[Date]),MAX(Data1[Date]))2. Result:
This way the slicer's date will always be between the table's min date and max date
This is the related document, you can view this content:
https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
https://community.powerbi.com/t5/Desktop/How-to-pass-the-date-parameters-in-PQ-Query/m-p/167291
Please click here for the pbix file.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi MiriamLeischner ,
I created some data:
You can create a date table, create a relationship with the table according to the date column, Keep the relationship is Inactive.
Here are the steps you can follow：
1. Create calculated table.
Date2 = CALENDAR(MIN(Data1[Date]),MAX(Data1[Date]))2. Result:
This way the slicer's date will always be between the table's min date and max date
This is the related document, you can view this content:
https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
https://community.powerbi.com/t5/Desktop/How-to-pass-the-date-parameters-in-PQ-Query/m-p/167291
Please click here for the pbix file.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly