I have three questions about data using PowerBI aggregate column charts.

[Anonymous]

three questions about data using PowerBI aggregate column charts.

What are three of the contents of the attachment?

Question (1)

    How do I display only the value "-50, -100" below y-axis 0?

Question (2)

    The y-axis currently shows rungs of -100, -50, 0, 50, 100, but how do I display rungs only at 0?

Question (3)

    How do I display data labels that are less than 0 in red, although the number of data labels is 18, 34, -28?

[Anonymous · Accepted solution]

It was really helpful.

I'm very grateful.

Thank you very much!

[v-easonf-msft]

Hi, @Anonymous 
1)It is difficult to achieve, currently you can only adjust the start and end positions of the y-axis. You can consider creating a rectangle with white background to cover it.
2)As a wokaround, you can create a constant line (value 0) to replace y-axis.

3)I'm afraid that there is no way to define two colors for y axis and data labels through conditional format．

You may need to manually set the data labels less than 0 to red.(Data labels->enable 'customize series'->column C->color: red)

Best Regards,
Community Support Team _ Eason