Forum Discussion

Jit007's avatar
Jit007
Helper II
2 years ago
Solved

Custom Sorting in measures (legend)

I'm unable to sort the data which comes from calculate measure as per below order,,any idea which steps needs to follow to correct the order   Excellent 1 Good 2 Average 3
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Create a static reference table in your data model. Keep it disconnected.

     

    Feed the visual from the first column, Use the measure to find the selected value and return the associated result.

lbendlin's avatar
lbendlin
Super User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Jit007's avatar
Jit007
Helper II
2 years ago

I need help to sort by in following order- Excellent >Good >Average

 Thanks lbendlin Anonymous 

 

 

Sorting.pbix attached file 

    • Jit007's avatar
      Jit007
      Helper II
      2 years ago

      new Sorting (2).pbix revised file attached..

       

      i'm trying to get the out of 100% monthly for ref id data - the total doesn't match to 100%

      Thanks in advance lbendlin 

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        like this?