Forum Discussion
Bar chart visual with positive and negative values
I was able to make it work using disconnected tables. Thank you for your suggestion. Much appreciated.
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).
Super UserThat 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.