Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Hi there,
I'm really stuck trying to sort these subvalues, by value, week, quarter and year
Like:
Weeks | value
1 | 20
1 | 15
1 | 9
--------------
2 | 25
2 | 23
2 | 20
The main problem is that i just have access to the data through PBI dataflows not the original source so i could not use
an extra table or column.
I found that maybe add calculated fields could work or rankx, but still nothing works.
Thanks in advance.
I want this order
per week
I want to sort in descending order every value per week
Like
Week 1
15,14, 10
Week 2
25, 20, 19
Hi @Anonymous, how are you wanting to sort them? What's the end output you're after?
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 42 | |
| 35 | |
| 35 | |
| 21 | |
| 15 |
| User | Count |
|---|---|
| 65 | |
| 58 | |
| 28 | |
| 27 | |
| 25 |