How can I add custom sort on Hierarchy Slicer in powerbi

[jaspreet27singh]

Dimensions = {

    ("Date", NAMEOF('table'[DATE]), 0,"Date"),

    ("Week", NAMEOF('table'[WEEK_START]), 1,"Date "),

    ("Month", NAMEOF('table'[DATE_B].[Month]), 2,"Date"),

    ("Advertiser ID", NAMEOF('DIM'[ADVERTISER_ID]), 3,"Platform"),

    ("Advertiser", NAMEOF('DIM'[ADVERTISER_NAME]), 4,"Platform"),

     }
This is the sample of parameter I am using to create slicer where  "Value 4" and "Value 1" are used in values field to create a slicer and it is showing Date options first and then Platform and so on.

I want to show "Platform" first and then "Date" right now it is showing alphabetically

[Anonymous]

Hi, @jaspreet27singh 

First, thanks for @Martin_D  reply. The display order in the slicer is really affected by the parameter after NAMEOF, which you can modify to display the desired order.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Martin_D]

Hi @jaspreet27singh ,

The bold numbers (see below) in your field parameter table define the display order. If you want to change the order, you can change the numbers. But be careful, each number should be unique in this column.

Dimensions = {

    ("Date", NAMEOF('table'[DATE]), 0,"Date"),

    ("Week", NAMEOF('table'[WEEK_START]), 1,"Date "),

    ("Month", NAMEOF('table'[DATE_B].[Month]), 2,"Date"),

    ("Advertiser ID", NAMEOF('DIM'[ADVERTISER_ID]), 3,"Platform"),

    ("Advertiser", NAMEOF('DIM'[ADVERTISER_NAME]), 4,"Platform"),

     }

Kind regrads,

Martin

[jaspreet27singh]

Hi @Martin_D,

It is not working as you mentioned above 

Dimensions = {

    ("Date", NAMEOF('table'[DATE]), 0,"Date"),

    ("Week", NAMEOF('table'[WEEK_START]), 1,"Date "),

    ("Month", NAMEOF('table'[DATE_B].[Month]), 2,"Date"),

    ("Advertiser ID", NAMEOF('DIM'[ADVERTISER_ID]), 3,"Platform"),

    ("Advertiser", NAMEOF('DIM'[ADVERTISER_NAME]), 4,"Platform"),

("Brand", NAMEOF('DIM'[BRAND]), 5,"Brand"),

    ("Product Name", NAMEOF('DIM'[PRODUCT_NAME]), 6,"Brand")

     }

using this and it is showing Brand on top then Date and Platform.

[Martin_D]

Hi @jaspreet27singh ,

Would you like to provide the following information to help understanding what you want?

• The pbix file, including the field parameter and the slicer
• A full screenshot, including the slicer with all levels expanded, the slicer's field configuration in the "Build" pane of Power BI Desktop and the "Data" pane of Power BI Desktop, and annotations what is wrong for you
• A drawing of what you want to see?

Thank you!

Kind regards,

Martin

[jaspreet27singh]

Hi @Martin_D ,

I am sharing all possible screenshot below.

By default "Date Dimension" is coming fisrt if you see slicer screenshot and requirement is to sort as per user requirement for example Platform first then Date

horizontally and vertically does'nt not work here because we have more in list 

slicer parameterThis one is fields I am using to create slicerslicerData part

[Martin_D · Accepted solution]

Hi @jaspreet27singh ,

Based on my understanding of your requirement, what you is a order-by column for column 'Dimensions'[Value4] as described here: Sort one column by another column in Power BI - Power BI | Microsoft Learn

To create the sort-by column, you can create a calcualted column in table 'Dimensions':

SortValue4 = IF([Value4]="Date Dimensions",2,1)

Kind regards,

Martin