title: Dont want to show bar if its value is 0 in CRM stacked bar chart
body: <p>I have created one stacked bar chart in CRM which have three Legend Entries. but I dont want to show the bar if its value is 0. It should hide in this case. My Chart XML is as below.</p>
  
  <pre><code>&lt;visualization&gt;
  &lt;visualizationid&gt;{02C1F86E-4421-E511-80E1-3863BB34FA68}&lt;/visualizationid&gt;
  &lt;name&gt;All Opportunity With Perfomance Target&lt;/name&gt;
  &lt;primaryentitytypecode&gt;opportunity&lt;/primaryentitytypecode&gt;
  &lt;datadescription&gt;
  &lt;datadefinition&gt;
    &lt;fetchcollection&gt;
      &lt;fetch mapping="logical" aggregate="true"&gt;
        &lt;entity name="opportunity"&gt;
          &lt;attribute groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" name="pav_salesperson" /&gt;
          &lt;link-entity name="pav_perfomancetarget" from="pav_perfomancetargetid" to="pav_perfomancetarget" link-type="outer"&gt;
            &lt;attribute alias="_CRMAutoGen_aggregate_column_Num_0" name="pnk_proposalissued" aggregate="sum" /&gt;
            &lt;attribute alias="_CRMAutoGen_aggregate_column_Num_13" name="pnk_proposalaccepted" aggregate="sum" /&gt;
            &lt;attribute alias="_CRMAutoGen_aggregate_column_Num_14" name="pnk_docsigned" aggregate="sum" /&gt;
            &lt;attribute alias="_CRMAutoGen_aggregate_column_Num_17" name="pav_perfomancetarget" aggregate="sum" /&gt;
          &lt;/link-entity&gt;
        &lt;/entity&gt;
      &lt;/fetch&gt;
    &lt;/fetchcollection&gt;
    &lt;categorycollection&gt;
      &lt;category alias="_CRMAutoGen_groupby_column_Num_0"&gt;
        &lt;measurecollection&gt;
          &lt;measure alias="_CRMAutoGen_aggregate_column_Num_0" /&gt;
        &lt;/measurecollection&gt;
        &lt;measurecollection&gt;
          &lt;measure alias="_CRMAutoGen_aggregate_column_Num_17" /&gt;
        &lt;/measurecollection&gt;
        &lt;measurecollection&gt;
          &lt;measure alias="_CRMAutoGen_aggregate_column_Num_13" /&gt;
        &lt;/measurecollection&gt;
        &lt;measurecollection&gt;
          &lt;measure alias="_CRMAutoGen_aggregate_column_Num_14" /&gt;
        &lt;/measurecollection&gt;
      &lt;/category&gt;
    &lt;/categorycollection&gt;
  &lt;/datadefinition&gt;
  &lt;/datadescription&gt;
   &lt;presentationdescription&gt;
  &lt;Chart Palette="None" PaletteCustomColors="91,151,213; 237,125,49; 160,116,166; 255,192,0; 68,114,196; 112,173,71; 37,94,145; 158,72,14; 117,55,125; 153,115,0; 38,68,120; 67,104,43; 124,175,221; 241,151,90; 186,144,192; 255,205,51; 105,142,208; 140,193,104; 50,125,194; 210,96,18; 150,83,159; 204,154,0; 51,90,161; 90,138,57;"&gt;
    &lt;Series&gt;
      &lt;Series ChartType="Column" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" /&gt;
      &lt;Series ChartType="Point" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" /&gt;
      &lt;Series ChartType="Column" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" /&gt;
      &lt;Series ChartType="Column" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" /&gt;
    &lt;/Series&gt;
    &lt;ChartAreas&gt;
      &lt;ChartArea BorderColor="White" BorderDashStyle="Solid"&gt;
        &lt;AxisY LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59"  TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"&gt;
          &lt;MajorGrid LineColor="239, 242, 246" /&gt;
          &lt;MajorTickMark LineColor="165, 172, 181" /&gt;
          &lt;LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" /&gt;
        &lt;/AxisY&gt;
        &lt;AxisX LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"&gt;
          &lt;MajorTickMark LineColor="165, 172, 181" /&gt;
          &lt;MajorGrid LineColor="Transparent" /&gt;
          &lt;LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" /&gt;
        &lt;/AxisX&gt;
        &lt;AxisY2 LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"&gt;
          &lt;MajorGrid LineColor="239, 242, 246" /&gt;
          &lt;MajorTickMark LineColor="165, 172, 181" /&gt;
          &lt;LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" /&gt;
        &lt;/AxisY2&gt;
      &lt;/ChartArea&gt;
    &lt;/ChartAreas&gt;
    &lt;Titles&gt;
      &lt;Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 13px" ForeColor="59, 59, 59" /&gt;
    &lt;/Titles&gt;
    &lt;Legends&gt;
      &lt;Legend Alignment="Center" LegendStyle="Table" Docking="right" IsEquallySpacedItems="True" Font="{0}, 11px" ShadowColor="0, 0, 0, 0" ForeColor="59, 59, 59" /&gt;
    &lt;/Legends&gt;
  &lt;/Chart&gt;
   &lt;/presentationdescription&gt;
   &lt;isdefault&gt;false&lt;/isdefault&gt;
   &lt;/visualization&gt;
  </code></pre>