custom sorting
2 TopicsHow can I add custom sort on Hierarchy Slicer in powerbi
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 alphabeticallySolved1.4KViews0likes6CommentsCustom sort two slicers from same table
Hi! Really hope someone can help! I have two slicers that corresponds to two different columns in the same table. I want to do custom sorting on both slicers, however i cannot seem to make this work. The table looks something like this: Key Column1 Column2 123 2 5 124 2 10 125 2 Free 126 5 5 127 5 10 128 5 Free 129 12 5 130 12 10 131 12 Free 132 Free 5 133 Free 10 134 Free Free I have tried creating a new table with the distinct values for column1 and the sort order, and then used the function "sort by column", which works for column1. However, I cannot seem to do this for the second column as well - in this case it tells me that the table is already sorted. Can anyone help?900Views0likes2Comments