cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Run a parameter to extract one name in a string of names but extract that name everywhere it appears

Hi All- 

 

I have a large dataset in which I would like to use a slicer to extract a text value (name) for every instance that the selected name shows up on the dataset. One issue is there are multiple names that are separated by commas that show up within a cell of a column. I would like the slicer to extract all records whenever that name shows up. 

 

I have read applying parameters is the way to go but since it is a large dataset; there are performance issues and takes a long time to refresh. Any ideas on how to proceed?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @rahul416 ,

 

You can create a parameter "Name" contains user names.

3.PNG

Then add a text filter on "name" column which contains the value of parameter.

2.PNG

4.PNG

Once you change the parameter, the result would be change.

5.PNG6.PNG7.PNG8.PNG

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

@rahul416 you cannot pass slicer value to underline data source to pre-filter the data, the only way is to create a parameter in your query use the parameter to filter the data using a parameter. check this video

 

https://channel9.msdn.com/Blogs/MVP-Azure/Pass-parameter-to-SQL-Queries-statement-using-Power-BI

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted

Unfortunately, the data structure lies in PowerBI so we aren't able to use SQL. Any options to do this in PowerBI?

Highlighted

@rahul416 you can filter in power query using a parameter?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Community Support
Community Support

Hi @rahul416 ,

 

You can create a parameter "Name" contains user names.

3.PNG

Then add a text filter on "name" column which contains the value of parameter.

2.PNG

4.PNG

Once you change the parameter, the result would be change.

5.PNG6.PNG7.PNG8.PNG

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors