Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |