Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am fairly new to Power BI Report Builder and have managed to create a report that displays the data from my dataset like I want, the only problem is I can't get the Parameter syntax correct for my user.
I have a ReportingDate field that has the date format of mm/dd/yyyy. I need to have the user enter which month value - mm (numerical) into the parameter to run the report. I have tried everything that I can find online to get it to work and still havent hit on the correct one.
I have a filter running right now to test choosing a month and it works fine, but I can't have the user change the filter all the time to run the report. I even created a calculated column called Month that pulls the numberical value out. I tried to use the Month calcluated column as the field for the parameter and that won't work either. Does anyone have an Expression syntax that will make the user enter the month number and pull the correct data? I have tried many of the ones from this site: Expression Examples (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs
Thank you for your assistance. I greatly appreciate any suggestions.
Deb
Hi @dmalways65 ,
Would you please share us the soultion of your issue to help others with the same issue?
Best Regards,
Dedmon Dai
Hi, @dmalways65
It would be best if you show us part of your dataset and the formulas that you have tried.
Show on screenshots what you need
I'm all set - I finally figured it out. Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |