Creating AND/OR searching

[Clowson]

Hello, 

I have been struggling to even determine if this is feasible, there is not a lot of material on non-finanical BI visuals. Sorry for the poor wording and please let me know ANY thoughts! 

I am creating a Medical history dashboard and I am trying to figure out a way to search by text for multiple conditions using AND / OR logic. 

As of right now, I use the standard text filter and search something like "scoliosis" to identify values from my data that are essentially wildcard "scoiosis". If I use a second text and type "Asthma" I get a sort of wildcard search for any value that has "scoliosis" and "asthma" in the same row. 

My data set is several hundred thousand rows of data and I am looking for a way to search by text for rows by wildcard values. So that if I search "scoliosis" and "asthma" it will look to different lines respectively, and not in the same line. I would like this to be built out to be able to use AND OR logic. IE, search for a patient who has had either condition or specifically both. 

Thank you. 

[Clowson]

Hello, 

thank you very much for the detailed information. 

One problem I may have is that I am trying to build this out for unqiue 55K rows, and want the end user to be able to type the key words for search, not just to create a view. 

[v-jtian-msft · Accepted solution]

Hi,@Clowson 

I am very sorry to say that the suggestions I have provided do not address your needs.

According to your description, you need to display a large amount of data (55k) while satisfying the user's customized confusing query data

Due to the large size of the data, it is not possible to display it directly in visual.

You may need to use other platforms than just the power BI service to solve your problem.

Below I give advice  that you can refer to.
       Use power BI fabric Lakehouse or Azure SQL DataBase .etc .

As the data is very large you can try to do ETL operation on the data at the data import stage.

Get the filtered data in advance and use it to build the report.

Here is the official documentation on this:
Tutorial: Microsoft Fabric for Power BI users - Power BI | Microsoft Learn
What is the Azure SQL Database service? - Azure SQL Database | Microsoft Learn

[v-jtian-msft]

Hi,@Clowson 
I am glad to help you.

According to your description you want to use And/Or logic to display the data in conjunction with text filtering?

If I understand you correctly, you can use power BI's Advanced filter function.

Here are my test results for your reference

Solution1:
Filter>Advanced filtering

I have filtered medcal_case1 with "bron" or "cold" by customizing the filter above.

You can also filter multiple columns at the same time if you have multiple columns of case data, and they are "And" related to each other.

like this.

Solution2:
If you want to filter on multiple columns and they are Or related, you can also proactively create calculate clolum columns to identify them and use the slicer to control the

like this:

Of course, this approach requires qualifying the data for a specific condition, so you will need to create multiple calculate columns if you use this approach.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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