Bar chart visual with positive and negative values

[gantaran]

I am working on a visual that will show a list of our plants with their monthly production capacity.  The visual will be used for planning downtimes.  If I select a plant (that is, a plant has a scheduled downtime), the visual should show the selected plant's capacity as a negative value, while the rest of the unselected plants will still be shown as positive values.  can you help me how I can achieve this?

[gantaran]

I thought so - I have been trying to use a horizontal clustered bar chart.  But I can't make it work.  First, my desired outcome is that all values should be shown as positive when nothing is selected (I have a slicer for the plant names).  What happens is that everything is negative when nothing is selected.  Second, if I select a plant, it will show the negative value (desired outcome) but the rest of the plants are not shown (should be shown as positive values).  

[lbendlin]

That seems to be a little unusual (A filter does filter stuff, it does not usually show the non-selected items.  If you need that behavior you would use disconnected tables for your filter.) What is the story you are trying to tell with your data?

[gantaran]

The visual should show the impact of a downtime of a particular plant and how the other plants can assist in providing the capacity that the unavailable plant needs to provide. 

[lbendlin]

Makes sense.  Use a disconnected table. 

What if more than one plant is offline?

[gantaran]

the expected bahavior will be the same.

[lbendlin]

Please provide sample data that fully covers your issue. In usable format (not as a screenshot).

[gantaran · Accepted solution]

I was able to make it work using disconnected tables.  Thank you for your suggestion.  Much appreciated.

[lbendlin]

That is standard functionality.  What have you tried and where are you stuck?