Custom sort drop down for asc and desc options for my tabular visualization

[Jn_01]

Hello all,
I wanted to make custom sort dropdown for asc and desc options for my tabular visualization.

I am able to sort using Ascending/Descending when I am having unique values but my detailed report has same values repeated multiple time for different dates.

My meausre

rankmeasure =

IF(

SELECTEDVALUE(SortTable[SortOrder])="1"

,RANKX(ALLSELECTED('SortOrder'[api_for]),CALCULATE( MIN('SortOrder'[Order])),,ASC,Dense)

,RANKX(ALLSELECTED('SortOrder'[api_for]),CALCULATE( MIN('SortOrder'[Order])),,DESC,Dense)

)
is working fine for distinct values (Summary report)

But for detailed report with multiple values of api_for it is not working.

Thank you.

[Anonymous · Accepted solution]

@lbendlin Thanks for your contribution on this thread.

Hi @Jn_01 ,

You can refer the following official documentation to sort the data of single or multiple fields in the visual directly just as @lbendlin referred:

Change how a chart is sorted in a report - Power BI | Microsoft Learn

In addition, please update the formula of your measure as below and check if it can return the expected result...

rankmeasure =
VAR SummaryTable =
    SUMMARIZE(
        'SortOrder',
        'SortOrder'[api_for],
        "MinOrder", CALCULATE(MIN('SortOrder'[Order]))
    )
RETURN
IF(
    SELECTEDVALUE(SortTable[SortOrder]) = "1",
    RANKX(ALLSELECTED(SummaryTable), [MinOrder], , ASC, Dense),
    RANKX(ALLSELECTED(SummaryTable), [MinOrder], , DESC, Dense)
)

Best Regards

[lbendlin]

What prevents you from using the default sort options (clicking on the column headers) ?