Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
It was really helpful.
I'm very grateful.
Thank you very much!
Hi, @eiji13579
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
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |