Sometimes you need to show the data in a reverse form for some of the other reasons. It’s not easy to reverse rows without Power Query in Power BI. Power Query can do it in a fraction of second without losing any valuable information.
Reverse Rows By Power Query
Let’s take an example where you have a data table showing the result for temperature and time as shown in the picture below.
Step1: To reverse the rows of the data table, perform the below step
Go to Transform > Reverse Rows
Step 2: Close & Apply
This will reverse all the rows as shown in the picture below. After you finish your task click on Close & Apply button to save the changes for later.
Acquire More Knowledge Here :
- Learn How to do Transpose in Excel
- Steps to Replace Values in Excel
- Read How to Group Rows And Get Counts Using Power Query
- Learn How to Create Pivot Columns Using Power Query