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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.