Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
chaitanya
Regular Visitor

How to put a dynamic parameter on the visualization page.

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.

3 REPLIES 3
makrand19
New Member

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. 

v-huizhn-msft
Microsoft Employee
Microsoft Employee

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

v-huizhn-msft
Microsoft Employee
Microsoft Employee

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).

1.PNG

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.