Forum Discussion
Power BI report builder parameter
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.
managed to do referring to this https://www.mssqltips.com/sqlservertip/5865/sql-server-reporting-services-report-builder-with-dax-query-support/
4 Replies
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) | Microsoft Learn
I added like below, but not working.
then, I just tried adding parameter under dataset
then, run but got below error
managed to do referring to this https://www.mssqltips.com/sqlservertip/5865/sql-server-reporting-services-report-builder-with-dax-query-support/
Thanks for letting me know.
