Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Column Chart Sub-categories sort

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

danielrr10_0-1646687097744.png

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.

3 REPLIES 3
Anonymous
Not applicable

I want this order 

danielrr10_0-1646689898423.png

per week

Anonymous
Not applicable

I want to sort in descending order every value per week 

Like
Week 1
15,14, 10
Week 2
25, 20, 19

TheoC
Super User
Super User

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.