Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
juancmr1
New Member

Problem with order of rows from query editor to apply changes

Hi,
I am new in Power Bi,  In my query editor I have  independent columns for date(dd/mm/yyyy) and time(HH:mm:ss) and other data. In the query editor my data is ordered chronologically. (example of my columns data headers:
Date                Time         ItemID                         DataValue1
17/03/2019      00:00:11  4B2E71BED93272CB    93.9477

 

When I close and apply changes the orders of the rows changes (I got mixed order in date and time rows). I need the data in cronollogical order so when I am ploting using scater chart the data is displayed in cronological order.


1.How can I do so when I close&apply changes in the query the order I have in the rows doesnt change?

2. I have tried to apply ordering filter options for the colums date and time in the power Bi desktop (after applying changes in the query editor) but since I have different colums for date and time I can not do that. Any recomendation??

3. My intention is to use scatter chart:
x-Axis: ItemNumber ( in cronological order with respect day and time-same order I have in my query editor data)
y-Axis: The corresponding DataValue1

 

thanks and looking forward to getting some help

1 ACCEPTED SOLUTION
rocky09
Solution Sage
Solution Sage

Try this, in the report view, select the Date field and then go to modeling and then Sort By then select Item Number.

View solution in original post

2 REPLIES 2
rocky09
Solution Sage
Solution Sage

Try this, in the report view, select the Date field and then go to modeling and then Sort By then select Item Number.

Thank you for your answer, it works!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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