Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
ChandraMukesh
New Member

Parameter for User Selection

‎01-08-2024 12:10 PM

Hi, I have created a Parameter in Power BI and I have a stored procedure that expects an input. So, I have used that parameter as an input to the stored procedure. Now I want that parameter to be shown as a drop down for the user selection so that it should display the charts as per the user selected month. Is it possible?

Labels:
Message 1 of 2
152 Views
0
1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

‎01-08-2024 08:14 PM

Hi @ChandraMukesh 

Unfortunately, we don't have this functionality in service.
The option for parameters from the service is only to enter the text/date value from the "special" field in settings:

Ritaf1983_0-1704773612014.png

more information is here :

https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Message 2 of 2
102 Views
0
1 REPLY 1
Ritaf1983
Super User
Super User

‎01-08-2024 08:14 PM

Hi @ChandraMukesh 

Unfortunately, we don't have this functionality in service.
The option for parameters from the service is only to enter the text/date value from the "special" field in settings:

Ritaf1983_0-1704773612014.png

more information is here :

https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Message 2 of 2
103 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

View All