Forum Discussion
I have three questions about data using PowerBI aggregate column charts.
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?
2 Replies
- v-easonf-msft
Community Support
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
