title: One Slicer for Power BI Desktop affecting multiple tables
body: <p>I'm setting up multiple tables on a single Page in Power BI Desktop, with plans to publish to an App. I'm using SQL Server as a data source to pull the output of three different pre-established System Views. Each of the Views pulls from the same set of original database tables, but presents a distinct grouping of orders. So for example one view might return:</p>
  
  <pre><code>Order # | Requested By | Reason Declined
  1       | Bob Smith    | too expensive
  3       | Jim Trout    | no space
  5       | Becky Bond   | not needed
  </code></pre>
  
  <p>and another might return:</p>
  
  <pre><code>Order # | Requested By | Number Items Approved
  2       | Jim Trout    | 5
  4       | Jim Trout    | 7
  </code></pre>
  
  <p>In short the three tables I have produced in Power BI have no overlapping "Order #" values (which is what I would otherwise use as a unique key for setting up relationships) and while there are shared columns like "Requested By" those don't contain unique values.</p>
  
  <p>I created a Slicer that uses the "Requested By" column for the largest of my three tables, but I'm trying to figure out if there is any way to make that one slicer affect all three tables. Is there any way to do this?</p>