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

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

Resolved?

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors