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
Harish85
Frequent Visitor

Give parameter on store number

Hi , I want to give Parameter value on column(Store Number) , when I pass store value , report should fetch only data related to that.

 

  if store number =16086 , then report should show only data related to that.

1 ACCEPTED SOLUTION
JadhavVarsha_13
Resolver II
Resolver II

Create new parameter from Home ribbon ( Power Query Editor), Select Any Value option from Suggested value dropdown, you can add 16086 to current value option. click on ok - it will create new parameter 

To apply that parameter - Go to the table, select column (store number) and in filter option select - Number Filters -> "Equals"  and you will have below window open, you can select parameter, as you already have passed required value there your data will be filtered basis to that value.

JadhavVarsha_13_0-1663240527625.png

You can update or change parameter value from here - 

JadhavVarsha_13_1-1663242519442.png

or once it is loaded you can change it from power BI desktop here 

JadhavVarsha_13_2-1663242615546.png

Hope this helps !

View solution in original post

2 REPLIES 2
JadhavVarsha_13
Resolver II
Resolver II

Resolved?

JadhavVarsha_13
Resolver II
Resolver II

Create new parameter from Home ribbon ( Power Query Editor), Select Any Value option from Suggested value dropdown, you can add 16086 to current value option. click on ok - it will create new parameter 

To apply that parameter - Go to the table, select column (store number) and in filter option select - Number Filters -> "Equals"  and you will have below window open, you can select parameter, as you already have passed required value there your data will be filtered basis to that value.

JadhavVarsha_13_0-1663240527625.png

You can update or change parameter value from here - 

JadhavVarsha_13_1-1663242519442.png

or once it is loaded you can change it from power BI desktop here 

JadhavVarsha_13_2-1663242615546.png

Hope this helps !

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.