Forum Discussion

Cali_2020's avatar
Cali_2020
Helper I
1 year ago
Solved

Custom Ranking & Scatter Plots

Hello!   I would love to achieve a scatter plot that can be filtered based on a ranking. I have looked at many youtube videos and spent hours on AI but I still can't achieve the right results. It's...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Here's some basic implementation

     

    you will notice that the R measure can also serve as a visual level filter.

lbendlin's avatar
lbendlin
Super User
1 year ago

instead of RANKX use the RANK function which allows sorting by more than one column.

 

Consider using a disconnected reference table with prepopulated rank options.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523