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
ManoBrasa
New Member

How can I change the sorting of a table column to another column?

Hi!

 

I created a new summarized table with the bellow structure:

DateDescSprintIdPointsIndex
25/10/22 00:00Resolved15658702256
25/10/22 00:00Resolved63802205
25/10/22 00:00Resolved74102206
25/10/22 00:00Resolved80902207
25/10/22 00:00Resolved159102214
25/10/22 00:00Resolved209402215
25/10/22 00:00Resolved323902216
25/10/22 00:00Resolved391402217
25/10/22 00:00Resolved15641802255
23/11/22 00:00Resolved15976802488
18/05/22 00:00Resolved15641801094
22/02/22 00:00Resolved1279280590
22/02/22 00:00Resolved1279290591
11/08/22 00:00Resolved12852301658

 

Desc (Description) - Resolved/Entered Issue/Scope Changed
Points - Is the story points from the Issue.

 

Table is sorted by Desc column and I want to sort by date. I try to use an index column to change the ordering but they duplicate some numbers in different rows.

How can I change the sorting of Desc column to one of date column or index column?

 

 

 

Index = RANKX('Burndow Summarized', RANKX('Burndow Summarized','Burndow Summarized'[Date],,ASC,Dense)+0.01*RANKX('Burndow Summarized','Burndow Summarized'[SprintId],,ASC,Dense)+0.02*RANKX('Burndow Summarized','Burndow Summarized'[Desc],,ASC,Dense)+0.03,,ASC,Dense)

 

 

 

 

My ultimate goal is to create accumulative measure for a burndown chart for each sprint.



2 REPLIES 2
iceparrot
Advocate II
Advocate II

Hey @ManoBrasa

 

you can open the  Data view  in Power BI Desktop an select the table you want to sort.  

iceparrot_0-1687156122665.png

Then klick on the column you want the table to be sorted accordingly and then open the Column Tools in the top navigation and select Sort by column. 

Then you can select the column you'd like to sort the table:

iceparrot_1-1687156263488.png

 

 

Please let me know if this solves your problem.

 

VahidDM
Super User
Super User

Hi @ManoBrasa 

 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

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.