Data show only when there is a score in a second set of data

[dnmrk]

I want to show a chart that dispays the NPS for a Team and the impact that team had on the overall NPS. However, I only want the chart to show the team in the axis if there is an NPS score, regardless of what the impact score is, as a Team with no NPS score would not have had any surveys in the specified timeframe and so is irrelevant.

How do I make the Impact data show only when there is a score in the NPS data? Cannot use Hide/ show items with no data as the impact always has data (0 on days with no survey). Cannot format so that 0 does not show as a teams impact can be 0 even with surveys. 

So in the example - I want the graph to show all teams but team B with NPS as a stacked column and Impact as a line.

Thank you!

[amitchandak · Accepted solution]

I am not sure I got it completely. But I would have preferred a scatter chart.

Can you please provide more details, what you are looking for.

[v-chuncz-msft · Accepted solution]

@dnmrk 

You may take advantage of Visual level filters.

[amitchandak · Accepted solution]

I am not sure I got it completely. But I would have preferred a scatter chart.

Can you please provide more details, what you are looking for.