Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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 :

jmclej2_0-1668686818379.png

But then, when I change from "Number" to "Sum", I get the expected graph EXCEPT that it reverses the "ExtractionDate"...

jmclej2_1-1668687352229.png

Why is that and how can I have the ExtractionDate in the correct original order AND the expected graph ?

2 REPLIES 2
amitchandak
Super User
Super User

Syndicated - Outbound

@Anonymous , Seem like you have sorted your visual on value, sort it on axis column

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user
Anonymous
Not applicable

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)