Sort Latest Month and Week Value

[vividarinda]

Hi all, I want to sort by last month based on the visual below. However, the rank value is not showing up.

File PBI : filePBIx 

Referring to the post below: https://community.fabric.microsoft.com/t5/Desktop/Sort-Latest-Week-Value/m-p/4065955#M1289495"

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but I tried to re-create relationship like below.

Please check the below picture and the attached pbix file.

[vividarinda]

Hi @Jihwan_Kim ,

First of all, thank you for the support provided. However, it still does not meet my expectations. What I am hoping for is that when I filter by date, the last 4 months will appear, and then the values for the most recent month shown in the visualization will be sorted. As shown below: 

For another example, if I apply a filter for a period of three months, say from May to July, the data displayed will be limited to these three months. In July, the data will be sorted by the highest values for that month. For instance, the correct order of values should be: 150, 100, 50.