Forum Discussion
Incorrect values in Y axis (line chart)
Hello!
I'm trying to add a line chart showing consumption/month by facility, with consumption on the Y axis. The problem is that, for some reason, these values are not ordered correctly in the chart. For example, the orange line appears on the top of the chart, even though it has the lowest consumption and therefore should be on the bottom. The series of values read correctly in the matrix to the left.
The problem was that Power BI was adding a "total" line, and that's why there was a line that appeared on top of the one I knew should been the one with the highest values.
3 Replies
click on the ellipsis (...) in the top right corner of your chart. Then specify which field to sort by and in which order.
Hi CaroSnowball ,
For visual, it is possible to customize the ascending or descending order according to the different fields, refer to the following screenshot.
For more details, you can read below document:
Change how a chart is sorted in a report - Power BI | Microsoft Docs
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.The problem was that Power BI was adding a "total" line, and that's why there was a line that appeared on top of the one I knew should been the one with the highest values.
