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 created a new summarized table with the bellow structure:
Date | Desc | SprintId | Points | Index |
25/10/22 00:00 | Resolved | 156587 | 0 | 2256 |
25/10/22 00:00 | Resolved | 638 | 0 | 2205 |
25/10/22 00:00 | Resolved | 741 | 0 | 2206 |
25/10/22 00:00 | Resolved | 809 | 0 | 2207 |
25/10/22 00:00 | Resolved | 1591 | 0 | 2214 |
25/10/22 00:00 | Resolved | 2094 | 0 | 2215 |
25/10/22 00:00 | Resolved | 3239 | 0 | 2216 |
25/10/22 00:00 | Resolved | 3914 | 0 | 2217 |
25/10/22 00:00 | Resolved | 156418 | 0 | 2255 |
23/11/22 00:00 | Resolved | 159768 | 0 | 2488 |
18/05/22 00:00 | Resolved | 156418 | 0 | 1094 |
22/02/22 00:00 | Resolved | 127928 | 0 | 590 |
22/02/22 00:00 | Resolved | 127929 | 0 | 591 |
11/08/22 00:00 | Resolved | 128523 | 0 | 1658 |
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.
Hey @ManoBrasa,
you can open the Data view in Power BI Desktop an select the table you want to sort.
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:
Please let me know if this solves your problem.
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/
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 |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |