Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
We have a requirement where in we have to display estimated revenue for opportunities for all the months in a year on x and y axis.
And we have multiple years and should have a parameter to select the year on the page. we have kept the parameter and when we save and publish the report as template when we open that in desktop it is asking to select a value before loading the data.
However our requirement is that we have to put the parameter for year on the visualization page as a dropdown with some predefined values so that customer can select the year and data should be shown for that year.
Ask: How to put the dynamic parameter on the visualization page.
We are using this power BI report in our Dynamics 365 dashboard.
Adding a Parameter and togelling them will only work on Desktop.
My reommendation would be to include data for all the years in the report and then use Scliers to filter them.
Hi @chaitanya,
Have you resolved your issue? If you have, welcome to share your solution. Or mark the right/helpful reply as answer. More people will benefit from here.
Best Regards,
Angelia
Hi @chaitanya,
To my knowledge, you create query parameter and list the predefined values in the list(highlighted in red line in the screenshot below).
Then save it as a template, when other people use and open it, it will be required by typing a value. More details, please review this article: Deep Dive into Query Parameters and Power BI Templates.
Best Regards,
Angelia
User | Count |
---|---|
120 | |
72 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |