title: Top 10%/Bottom 10% Conditional Format from Exel in Power BI Matrix Visual
body: <p>I am attempting to replicate Excel's top/bottom 10% conditional formatting functionality using a Power BI matrix visual. Data is Likert scale survey responses, and to evaluate, I am calculating the percent of disagreeability for each question using a measure (DAX code below) .</p>
  <pre><code>    Calc Personnel = 
  (CALCULATE(
      Counta(data[My unit of assignment is:]),
      Filter(data,data[There are an adequate number of personnel assigned to my unit to perform the mission.]=&quot;Disagree&quot;)) +
  CALCULATE(
      Counta(data[My unit of assignment is:]),
      Filter(data,data[There are an adequate number of personnel assigned to my unit to perform the mission.]=&quot;Slightly Disagree&quot;)) +
  CALCULATE(
      Counta(data[My unit of assignment is:]),
      Filter(data,data[There are an adequate number of personnel assigned to my unit to perform the mission.]=&quot;Strongly Disagree&quot;))
  )
  /
  (
  CALCULATE(
      Counta(data[My unit of assignment is:]),
      Filter(data,data[There are an adequate number of personnel assigned to my unit to perform the mission.]=&quot;Agree&quot;)) +
  CALCULATE(
      Counta(data[My unit of assignment is:]),
      Filter(data,data[There are an adequate number of personnel assigned to my unit to perform the mission.]=&quot;Slightly Agree&quot;)) +
  CALCULATE(
      Counta(data[My unit of assignment is:]),
      Filter(data,data[There are an adequate number of personnel assigned to my unit to perform the mission.]=&quot;Strongly Agree&quot;)) +
  CALCULATE(
      Counta(data[My unit of assignment is:]),
      Filter(data,data[There are an adequate number of personnel assigned to my unit to perform the mission.]=&quot;Disagree&quot;)) +
  CALCULATE(
      Counta(data[My unit of assignment is:]),
      Filter(data,data[There are an adequate number of personnel assigned to my unit to perform the mission.]=&quot;Slightly Disagree&quot;)) +
  CALCULATE(
      Counta(data[My unit of assignment is:]),
      Filter(data,data[There are an adequate number of personnel assigned to my unit to perform the mission.]=&quot;Strongly Disagree&quot;))
  )
  </code></pre>
  <p>I would like to have the matrix visual look like the Excel table (see image below), but I have not stumbled upon the DAX code that will allow me to accomplish this. Any help is greatly appreciated!</p>
  <p>Additionally, if there is another approach to calculating the percent of disagreeability for each question, I am willing to listen to all suggestions.</p>
  <p><a href="https://i.stack.imgur.com/3F2qx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3F2qx.png" alt="Excel Top/Bottom 10% Cond Format" /></a></p>