Small multiples - display positive and negative values

[Anonymous]

Hello, 

I would like to create a small multiples chart that displays data with positive and negative values. When I create the chart, it seems that only positive values are displayed. I cannot edit the y-axis range to start at a negative number and end on a positive one. The only way I can get negative values to show is if the entire sample set is negative. 

Is it possible to have a small multiples chart display a mix of positive and negative values? 

This what my chart looks like now. The spaces in between bars are negative and not displayed.

I would like it to look like this: 

[v-kkf-msft]

Hi @Anonymous ,

I am able to display negative values correctly. Could you adjust the minimum value of the Y-axis, for example by entering -10.

Best Regards,
Winniz

[Anonymous]

Hi Winniz,

Thanks for the help!

I have tried adjusting the axis as you demonstrated but the box becomes outlined in red and the axis doesn't adjust, so it looks like it can't do it. What version of Power BI are you using? Perhaps I need to upgrade to get this feature as I'm on October 2021 version. 

[v-kkf-msft]

Hi @Anonymous ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[v-kkf-msft]

Hi @Anonymous ,

I am using the version: 2.106.582.0 64-bit (June 2022)

the visual: Clustered column chart

Best Regards,
Winniz

[Anonymous]

Hi amitchandak,

Yes, I have tried both bar and column chart. The same behaviour happens with both. 

[amitchandak]

@Anonymous , hope you are using bar visual ?