Separate positive values from negative values in same month (axis)

[dvhez]

Hi everyone. As you can see in the stacked column chart below, I have some values that are separated by month and by technology in the same column. However, this is showing me the NET value and I'd like to differentiate how much was negative and how much was positive for the same month.

I added another column to my table which basically tell if certain value is positive or negative. For example, the next chart shows the pos and neg values for the month of August 2018.

My practical solution until know is to put two different charts in my report, one with the positive values and other with the negative ones, but I wanted to know if there's something I could do or a different approach to this.

Thanks a lot!

[Ashish_Mathur · Accepted solution]

On the x axis of the chart, drag the new column that you have created (along with the month column which you already have there).

[dvhez]

Oh silly me... I tried that before posting these but forgot to expand to the lower level. Thanks a lot!

[Ashish_Mathur]

You are welcome.

[dvhez]

Hi Ashish, can I ask you a last question if you don't mind please. I'm getting this result (which is OK), but is there a way to put together those columns who belong to the same year/month?.

[Ashish_Mathur]

I do not understand your question.  Show a picture of your desired result.

[dvhez]

I've just found it isn't possible and is still under review https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6804910-clustered-stacked-chart

Thanks btw!