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

Visuals for AND/OR searches

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. 

2 ACCEPTED SOLUTIONS

The advanced filter options in the filter pane allow you to do an OR search of "contains" , but only for two terms.  You can check the market place for custom visuals that may have more options.

View solution in original post

Hi,

 

You can unhide your reports filter pane and publish your report.I hope it will help you.

View solution in original post

7 REPLIES 7
Clowson
Regular Visitor

More than two terms from a single column. Using AND OR logic as its linked back to a patient list 

The advanced filter options in the filter pane allow you to do an OR search of "contains" , but only for two terms.  You can check the market place for custom visuals that may have more options.

Is there any way to have the user do this from the dashbaord? Even two is better than 1. I just use the text filter but that only gets us one, is there a way to enter two lines of text for the same advanced filtering?

 

I am having a lot of trouble determining if I can build that out. thank you for the help, I am still learning the best way to ask these questions 

lbendlin_0-1716481121627.png

 

Hi,

 

You can unhide your reports filter pane and publish your report.I hope it will help you.

Could you elaborate on this please, how will the user be able to use this?

lbendlin
Super User
Super User

Please clarify:  Are you expecting to be able to search across columns in a row?  Are you expecting to be able to search for more than two terms?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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

Top Solution Authors