https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/AND-OR-visual/m-p/3940804#M9672 <P>Hello,&nbsp;</P><P>I have been&nbsp;<STRONG>struggling&nbsp;</STRONG>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!&nbsp;</P><P>&nbsp;</P><P>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.&nbsp;</P><P>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.&nbsp;</P><P>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.&nbsp;</P><P>&nbsp;</P><P>Thank you.&nbsp;</P> Wed, 22 May 2024 20:51:04 GMT Clowson 2024-05-22T20:51:04Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/AND-OR-visual/m-p/3940804#M9672 <P>Hello,&nbsp;</P><P>I have been&nbsp;<STRONG>struggling&nbsp;</STRONG>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!&nbsp;</P><P>&nbsp;</P><P>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.&nbsp;</P><P>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.&nbsp;</P><P>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.&nbsp;</P><P>&nbsp;</P><P>Thank you.&nbsp;</P> Wed, 22 May 2024 20:51:04 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/AND-OR-visual/m-p/3940804#M9672 Clowson 2024-05-22T20:51:04Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/AND-OR-visual/m-p/3967057#M9779 <P>As long as you only need to check for two conditions you can use the Filter Pane, Advanced Filter.</P> Sun, 02 Jun 2024 23:49:34 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/AND-OR-visual/m-p/3967057#M9779 lbendlin 2024-06-02T23:49:34Z