Need help: How to search a specfic text in column

[xiumi_hou]

Dear all,

I have a column, and it all show "See detailview" like this:

However, when I expend this column, the actual value stored in this column like this , this is what I actually want to search in this column, is this something I can fix by power BI or this is fixed by the pre-set up in our database? Thank you so much for your help: 

[amitchandak]

I am not sure I got it completely. But please refer

https://community.powerbi.com/t5/Desktop/Search-text-within-drop-down-filter/td-p/428492

https://exceleratorbi.com.au/text-filtering-power-bi/

https://docs.microsoft.com/en-us/dax/search-function-dax

https://community.powerbi.com/t5/Desktop/Search-functionality-in-Power-BI/td-p/48264

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[xiumi_hou]

Thank you so much for answering. Actually, for the firstpicture I showed - column 'Name', you can see it all showe "See DetailView", Actually what real stored for each line is like the second picture. Is there a way I can search the real text that stored in the database? Thanks!

@amitchandak 

[natabird3]

Also you can use the ask a question button to search directly the data:

[natabird3]

if you select the filter option and the values you can search there by selecting the 3 dots on the top. However, to display the data that you have maybe you need to change the format to text.

[v-lid-msft]

Hi @xiumi_hou ,

So there are multi values in each rows ? Could you please share about what kind of data source you are using and the data connective mode? How about the result if you put this field into a slicer? Please don't have any Confidential Information or Real data in your reply.

Best regards,

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