Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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? ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    It was really helpful.

    I'm very grateful.

    Thank you very much!

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

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