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 th...
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? Thanks
anys23
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.