Forum Discussion
Bar chart visual with positive and negative values
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?
I was able to make it work using disconnected tables. Thank you for your suggestion. Much appreciated.
8 Replies
That is standard functionality. What have you tried and where are you stuck?
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).
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?
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.
