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).
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?
