cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danielrr10
Regular Visitor

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
danielrr10
Regular Visitor

I want this order 

danielrr10_0-1646689898423.png

per week

danielrr10
Regular Visitor

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 @danielrr10, 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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.