title: Search on multiple columns
body: <p>In my PowerBI App I have a visual tool called 'Text Filter' that provides a text search tool for finding data quickly for a single column of data in the table.  The problem is that I want it to
  search on multiple text columns instead of just one.</p>
  <p>I created a calculated column that combines all the text columns I want to search:</p>
  <p>DAX</p>
  <pre><code>srch_data = [Item No] &amp; &quot;~&quot; &amp; [DocumentNo] &amp; &quot;~&quot; &amp; [OrderNo] &amp; &quot;~&quot; &amp; [Description] &amp; &quot;~&quot; &amp; related(Posted_AR_Header[External_Document_No_]) &amp; &quot;~&quot; &amp; RELATED(Posted_AR_Header[No]) &amp; &quot;~&quot; &amp; RELATED(Posted_AR_Header[ShiptoAddress]) &amp; &quot;~&quot; &amp; RELATED(Posted_AR_Header[ShiptoCity] )
  </code></pre>
  <p>Next, I applied the new calculated column (<code>srch_data</code>) to the <code>Text Filter</code> visual tool.</p>
  <p>It all works fine but it seems like there should be a better way to highlight/filter row data that meets the search criteria for multiple columns in the table.</p>
  <p>Is there a better way to search for text in multiple columns??</p>
  <p>9/3 update - Apparently there is not a better way to do this...</p>
  <p><a href="https://community.powerbi.com/t5/Desktop/Search-on-multiple-columns/m-p/2054886#M768023" rel="nofollow noreferrer">https://community.powerbi.com/t5/Desktop/Search-on-multiple-columns/m-p/2054886#M768023</a></p>