Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Small multiples - display positive and negative values

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: 

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak,

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        v-kkf-msft
        Community Support
        4 years ago

        Hi Anonymous ,

         

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

        the visual: Clustered column chart

         

        Best Regards,
        Winniz