title: How can I have dynamic axis which is responsive on slicer value, without using bridge table, use just DAX
body: <p><img src="https://i.stack.imgur.com/uSlGK.png" alt="Dashboard Image"></p>
  
  <p>Hi everyone, I have a chart which I need that the x value (Axis) changes by changing the slicer value (this slicer is the yellow one that has all the Dims (x values)) and it comes from <code>DimList</code> table. For example, at the moment the chart is <code>totalfreight</code> by <code>custid</code>, but I need if I check the <code>empid</code> from the yellow slicer the chart value changed to <code>totalfreight</code> by <code>empid</code>. This happens for all of the slicer values.</p>
  
  <p>But I don't like bridge table or any method that has a bad effect on performance because the <code>FactTable</code> has a billion rows and I modeled it in SSAS, tabular model and has a live connection. Thanks in advance.</p>