title: Power BI - Switch table structure depending on what is selected
body: <p>I'm trying to understand the workflow and how to think when working with Power BI.</p>
  
  <p>I'm trying to create the visual side of a logging framework using azure application insights and log analytics in the background.</p>
  
  <p>What I got stuck on right now is using a visualization for different table structures.</p>
  
  <p><strong>Scenario:</strong></p>
  
  <p>So lets say I have an integration workflow that is compiled of different components (starts at one endpoint, being processed and sent to destination endpoint), and this workflow is used in parallel depending on the endpoints.</p>
  
  <p>Visualization:</p>
  
  <pre><code>A ----&gt; (integration process) -----&gt; B
  C ----&gt; (integration process) -----&gt; D
  
  A &lt;---- (integration process) &lt;----- B
  C &lt;---- (integration process) &lt;----- D
  </code></pre>
  
  <p>In this process I'm logging traces and exceptions for each workflow for example.</p>
  
  <p>And lets say I have extracted the power BI query from log analytics to import the data into Power BI.</p>
  
  <p>Now as you can see above I have an "Send" and "Receive" flow for both sets of endpoints per parallel integration so to speak and I want to be able to pair these per report in Power BI.</p>
  
  <p><strong>Problem:</strong></p>
  
  <p>So then to my problem for now;</p>
  
  <p>Let's say I want to put a doughnut chart with total amount sent AND received messages.</p>
  
  <p>Also when clicking on the different parts of the chart I want to change the containing data and also the structure of the single table in the same report.</p>
  
  <p>What I'm struggling with is using a table to display the content of two workflows that are related to each other in the sense of being a "Sent and received" visualization of the integration, but don't have any hard drawn relations to each other in code.</p>
  
  <p>I was reading something about a switch statement but I thought i'd ask the question here to learn "the way of thinking" when using Power BI.</p>
  
  <p><a href="https://i.stack.imgur.com/xPq83.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xPq83.png" alt="enter image description here"></a>          </p>
  
  <p>Hope I made my problem clear by the description above, if I forgot anything please ask and I'll do my best to try to further explain what I'm asking for.</p>
  
  <p><strong>EDIT</strong>:</p>
  
  <p>Ok so regarding the feedback i got of the question being to broad, does it help i i would say i want to be able to switch everything in a Table (that is: all columns and values), by a clickable slicer for example.</p>
  
  <p>why i'm trying to achieve is something similar to this, but for a table view:</p>
  
  <p>Youtube Link:
  <a href="https://www.youtube.com/watch?v=UsAJPIANAb8&amp;t=71s" rel="nofollow noreferrer">Using SWITCH True Logic In Power BI - DAX Concepts</a></p>
  
  <p>Do i select the content of a table with a measure-query or do i have to do any other special fix to get this to work?</p>
  
  <p>Hope this clarify the problem i'm working on. </p>