Forum Discussion

Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

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's avatar
vividarinda
Helper II
2 years ago

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.