Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Clowson
Regular Visitor

Creating AND/OR searching

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. 

1 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

View solution in original post

3 REPLIES 3
Clowson
Regular Visitor

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. 

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
Community Support
Community Support

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

vjtianmsft_0-1716430203229.png

vjtianmsft_1-1716430231194.png

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.

vjtianmsft_2-1716430289065.png

 

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:

vjtianmsft_3-1716430345771.png

 

vjtianmsft_4-1716430353680.png

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.