Skip to main content

Power BI

New

Manual control of order of dimension members

Vote (3) Share
's profile image

on 28 Jul 2018 01:54:30

I can't believe i can't manually control the order that a list of dimension members appear on the axes. Yeah i know i can click on the corner and select a-z or order them by the numeric value but if you have textual dimension members that should be ordered in a specific way you have no ability to order them that way...Tableau makes this so much easier

Comments (1)
's profile image Profile Picture

c2ad7c70 53d2-4b4e-b8e1-96ec1ca4c595 on 05 Jul 2020 23:36:37

RE: Manual control of order of dimension members

You simply have to add another field with the order value and then choose the "Sort by Column" option in the modelling tab, to assign the new order field to the text field. This is standard practice with for example sorting Month names Jan, Feb etc.