3 Replies Latest reply: Apr 3, 2018 6:21 PM by Wayde Carter RSS

    Hiding non-associated entries in bar charts when using filters

    Wayde Carter

      Hi,

       

      I must be missing something here or maybe the standard QS bar chart just doesn't do it easily.

       

      A user wants to show all audit categories on a stacked bar chart along with the count of measures by status (which in the chart below are color-coded).

       

      Bar Chart Issue LE.PNG

       

      When the user makes a filter selection, they want any audit categories that are not associated with a filter selection to be hidden on the bar chart.  In the chart below, once the filter is selected, these have changed to black.  The black ones are the audit categories we want hidden.

       

      Bar Chart Issue LE FAM Filter.PNG

       

      I know this is possible with a pivot table, but is it possible with a stacked bar chart and if so, how can it be done?

       

      Kind regards,

      Wayde