Forum Discussion
Find user selected string in a field
Hi,
I have a dataset similar to this
| Product | Tags |
| Apple iPhone | Mobile Phone|Telephone|iPhone|Apple|Smart Device |
| Dell Laptop | Laptop|Dell|Computer|Folding|Gaming |
| HP Printer | Printer|Device|Output|Smart Device |
I would like to give list of tags to the user:
Mobile Phone
Telephone
iPhone
....
....
Smart Device
Based on user selection, I would like to show the products that has these tags.
I have different calculations on the products, so it would be great if this can be a filter, and does not need to be integrated in all the calculations.
Plan is to put this filter on for the whole report, so whenever the user selects a tag, the report will only show calculations on filtered data.
Would be nice for the user to be able to select multiple tags.
Many thanks
Hi Anonymous ,
You can refer the following links to get it:
Solved: Re: How to filter/slice for multiple string values... - Microsoft Fabric Community
Solved: Re: Filtering Data by containing string values - Microsoft Fabric Community
If the above one can't help you, please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
1 Reply
Hi Anonymous ,
You can refer the following links to get it:
Solved: Re: How to filter/slice for multiple string values... - Microsoft Fabric Community
Solved: Re: Filtering Data by containing string values - Microsoft Fabric Community
If the above one can't help you, please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards