Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
Solved! Go to Solution.
Try this, in the report view, select the Date field and then go to modeling and then Sort By then select Item Number.
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
55 | |
38 | |
31 |
User | Count |
---|---|
71 | |
64 | |
60 | |
50 | |
45 |