Create date parameter

[rosesmary]

I have a date set with 3 columns: Category, Date and Event Count.

I would like to create a summary table on my dashboard where the first column is Category, second column is total of event count based Date1, third column is total of event count based on Date 2.

I want Date 1 and Date 2 to be chosen by user. Of course Date 1 and Date 2 must be limited by the available dates in the data

How do I create such paramters. I can do that in Tableau but not sure how to achieve the same object with Power BI?

Thanks

[jbarwegen]

have you found a soluton to this? i have the same problem i'm trying to solve

[v-lili6-msft]

hi, @rosesmary

 You can try to use Parameters in Power BI Edit Queries. here is the tutorial for you to refer to:

Reference:https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

Best Regards,

Lin

[PattemManohar]

@rosesmary Any sample data and expected output will be helpful