Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I'm trying to create a postcode search (UK) and only want the postcode to be selected when an exact match has been typed in the search bar. This then triggers other text to change on the dashboard.
For instance I only want the exact W11 1AJ to be picked up and not for users to have to select the corrent postcode.
Any ideas?
Solved! Go to Solution.
Hi @Anonymous ,
Based on my research, it is by design to search the related items, maybe you could try to use Smart Filter by OKViz custom visual to achieve your result:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380859?tab=Overview
Sample data:
Result:
Regards,
Daniel He
Hi @Anonymous ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi Im expiriencing the same issue, and smart filter dosent enable pasting in the regular version
is there any other solution?
Hi @Anonymous ,
Based on my research, it is by design to search the related items, maybe you could try to use Smart Filter by OKViz custom visual to achieve your result:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380859?tab=Overview
Sample data:
Result:
Regards,
Daniel He
Would a text filter search box work instead of a slicer? If you search text filter in the marketplace it will appear. I believe this might resolve your issue.
@Anonymous that still picks up the other postcodes that contain the shorter postcode. Using the same example, all 5 postcodes are selected when I only want the W11 1AJ selected. I essentially want to be able to do the search as if it had speech marks around the text.
Hi, were you able to find a solution for text search with exact match ?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
96 | |
90 | |
81 | |
69 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |