Report Builder Date Type Filter Selection

[VoijaRisa]

I am working on developing a report in the Power BI report builder and running into an issue with filtering dates. The issue seems to stem from the fact that we want to give users the option on what type of date to filter on as the data set has several options (Invoice_Date, Process_Date, Payment_Date, etc....)

So I've created three parameters:

• Date_Choice - stores which date field to filter on. Stored as text.
• Start_Date - stores the beginning date for the SQL query. Stored as date/time
• End_Date - stores the end date for the SQL query. Stored as date/time

and added the following to the WHERE clause in the query:

WHERE 
  [other clause elements]
  and @Date_Choice >= @Start_Date
  and @Date_Choice <= @End_Date

However, when running the report, we have observed that these lines to not appear to be having any effect. It does appear to work if I hard code the date field (ex., "and INVOICE_DATE >= @Start_Date"). So the issue seems to be with the Date_Choice parameter. I've been unable to determine why. Any insight?

[parry2k]

@VoijaRisa what is your data source? If it is pure SQL you have to build that logic in your SQL query

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[VoijaRisa]

The data source is MS Azure SQL database. The WHERE clause I posted is in the SQL query. Is that what you mean?