Power BI report builder parameter

[dogburalHK82]

Hi, 

I am trying to use parameter (like slicer) to filter the value in datasets. 

Quality_Defect is from Dax in power bi service; whereas PO is a fact table  from power bi service

Quality_Defect (NCR)

PO (Delivery_Sch)

Parameter (Supplier name)

When I run the model, it shows blank in report. 

Please advise what I missed. 

Also, how do I set a date parameter, ranging from date to date? I only could do a single date selection.

[GilbertQ]

Thanks for letting me know.

[GilbertQ]

Hi @dogburalHK82 

You have to pass the parameter into your query.

Here is an example on how to do this: Tutorial: Add a Parameter to Your Report (Report Builder) - SQL Server Reporting Services (SSRS) | M...

[dogburalHK82]

@GilbertQ 

I added like below, but not working. 

then, I just tried adding parameter under dataset 

then, run but got below error

[dogburalHK82 · Accepted solution]

@GilbertQ 

managed to do referring to this https://www.mssqltips.com/sqlservertip/5865/sql-server-reporting-services-report-builder-with-dax-qu...