Forum Discussion
Custom soer columns using data cubes
Hi guys!
I am building basic column chart with sales values. My problem: Only way I can sort columns by default is by value or by alphabetical order. I need my own order but I cannot achieve that through any metric I have in my data cube. I discovered that this can be done with adding an extra column in data. However in my Power BI I cannot do anything in Power Query (I see options but cannot click them). Is there a way how to solve this problem?
I would upload an image but it is not working. 😕
Thank you!
Anna
4 Replies
anys23 , if you already have a column than you can mark that a sort column, In live connection you are not allowed to create a column,
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Thank you for your answer.
I am in Power BI desktop, not live.I have saels data of the sequence of e-mails and I need those emails in order as they are sent out (30pre, 15 pre, 7pre, 0pre, 7pos, etc..)
How can I custom sort them? The approach you proposed I cannot do because I cannot click on those option. I have a suspition that is due to data cube as a source.
Do you have any other ideas? Thanksanys23
amitchandak meant you are using live connection mode, so you cannot open Query Editor nor add columns to the model.Try create a dax measure instead of column, maybe rankx? and sort by the measure.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
