Sorting based on a slicer values selection

[MKPBI_2805]

Any help for Sorting based on a Slicer Value Section. Slicer will have the Column Names as List of Values used in a Table.

[v-gizhi-msft · Accepted solution]

Hi,

Here is my test sample:

Please take following steps:

1)Create a slicer table by Enter Data:

2)Try this measure:

Measure = 
SWITCH (
    SELECTEDVALUE ( SlicerTable[Slicer] ),
    "Sort by Date", RANKX (
        ALLSELECTED ( 'Table' ),
        CALCULATE ( MAX ( 'Table'[Date] ) ),
        ,
        ASC,
        DENSE
    ),
    "Sort by Target_Sales", RANKX (
        ALLSELECTED ( 'Table' ),
        CALCULATE ( SUM ( 'Table'[Target_Sales] ) ),
        ,
        ASC,
        DENSE
    ),
    RANKX (
        ALLSELECTED ( 'Table' ),
        CALCULATE ( SUM ( 'Table'[Actual-Sales] ) ),
        ,
        ASC,
        DENSE
    )
)

3)Add this measure to the table visual, and set this visual sort by above measure:

4)When selecting one value in slicer, the result shows:

See my attached pbix file.

Best Regards,

Giotto

[amitchandak]

@MKPBI_2805 , You have the option to choose a sort column, which means it is static. means no option to change.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

What is that you want to achieve.

[PattemManohar]

@MKPBI_2805  Don't think it is possible (As of today), to make sorting order by expression based (or selection based).

But will be interested in other community members thougts as well on this.