title: PowerBI: Club some values together without creating new column
body: <p>In PowerBI, I have some values in a column like R1, R2, R3, R4, R5 for each issue id. I want to use this data to plot a bar chart with 3 bars (R5 as High, R4 and R3 as Medium &amp; R2 and R1 as Low) with each bar having respective count of issues. How can I do this without creating a new column or measure? If I have to use a new measure or column, what is the more efficient way of doing it?</p>
  
  <p>NOTE: Number of rows is expected to cross 100K and data refresh is expected every 15 mins.</p>