- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

why does the data order on the X axis in a chart line graph change when I change its aggregation ?
Hello,
I have a table which is the result of a group by, so it has 1 column ExtractionDate (texte format : "20221225") and 1 column "Number of lines" (which is a integer).
In the data model, I have set "Number of lines" to "Do not summarize". First, why does Power BI chooses "Sum" by default instead of "Do not summarize" here ? I would think that if I want to do additional calculations, I would do it myself...
I then want to display this in a line chart. I put ExtractionDate in my X axis and "Number of lines" in my Y axis. By default it chooses the aggregation "Number" for my Y axis. I get that (the ExtractionDate is in the right order because I have sorted the data that way in my transformation steps) but it is not of course the graph I want to show :
But then, when I change from "Number" to "Sum", I get the expected graph EXCEPT that it reverses the "ExtractionDate"...
Why is that and how can I have the ExtractionDate in the correct original order AND the expected graph ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
I did nothing else that what I've described above.
What is this difference you make on sorting the visual on "value" or on "axis column" ?
For you the behaviour I have is normal ? I don't understand the logic behind, if you can enlighten me please.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-02-2023 03:16 AM | |||
10-03-2023 02:25 AM | |||
06-17-2024 08:13 AM | |||
11-03-2023 12:54 AM | |||
12-18-2023 11:50 AM |
User | Count |
---|---|
141 | |
115 | |
83 | |
63 | |
48 |