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

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

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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