Forum Discussion

Clowson's avatar
Clowson
Frequent Visitor
2 years ago
Solved

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!    ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.