title: Power Bi clustered column chart with multiple sorting
body: <p>I have a clustered column chart in power bi. I have a measure as a value. I have years as legend. I want to order the value by the highest value of the highest year and ignore the other years.
  For example (let’s call my measure IPTV)</p>
  
  <pre><code>Level1   | Year | IPTV
  ---------|------|-----
  Actuator | 2019 | 0.5
  Actuator | 2018 | 4.5
  Seal     | 2019 | 1.5
  Seal     | 2018 | 2.5
  </code></pre>
  
  <p>I want seal first as it has highest value for 2019 at this point I don’t care what the value of 2018 is.
  I have year in legend. And IPTV in value and level2 in Axis.
  Any help will be greatly appreciated.</p>