Hide line based on filter in Line and Clustered bar chart

[Anonymous]

Hi Experts,

Need ur help in this issue.

I am working with Line and Clustered bar graph, which shows sales in each month representing Bars. We have a slicer named "City". For some cities we have a "Target Value" which is being represented as Line in the graph.

Now the issue is, for some cities, we do not have Target, that means, we do not want to show the Target Line in the Graph. In the data source, for these cities values are "NULL". 

Please advise, how can we hide and show the Target Line based on the selection of City.

Thanks.

[v-piga-msft]

Hi @Anonymous ,

By my test, if you don't have the target values for the city, if you select the city option under slicer, it will not show the target line in Line and Clustered bar graph.

Assuming that you have the data sample below.

Here is the output.

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

Best  Regards,

Cherry