Hiding non-associated entries in bar charts when using filters

[waydec_ses]

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).

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.

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

[kkkumar82]

I think the black ones are also the associated ones as they are coming up with some values , but according to your question when there are no associated values for a selection they shouldn't come up ,this is strange

[agigliotti]

what is your chart measure and what is your field selections ?

[waydec_ses]

Hi Andrea and Kiran,

Based on your comments, I checked out the measure created by the user, removed the set analysis expression and created a conditional sum(if(..., 1,0)) expression.  Selection using an associated filter now shows the relevant audit categories on the stacked bar chart.

Thank you both for your contributions and time.

Wayde