User-Maintainable Date Parameter

[MiriamLeischner]

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?

[v-yangliu-msft · Accepted solution]

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