7 Replies Latest reply: May 12, 2011 10:26 AM by arungurumurthi RSS

    Combine 2 measures in one bar

      Hi,

       

      I am trying to create a bar chart with two measures Performance & opportunity and want the graph to have only one bar for Opportunity such that if Performance is less than Opportunity (Say 50 %) then 50% of Oppotunity line should show as green and remaining 50 % of the Opportunity bar should show as red.

       

      Also i have another measure Target. I want to show a vertical line in each bar as a mark for target.

       

      Please advice how to acheive this.

       

      Thanks

      Arun