Sorting a graph after values from max year

[cosminc]

Hi

is there a posibility in a graph with 3 years sales by salesmen to sort a top salesmen but after sales from max year?

i use a measure as value

Thanks,

Cosmin

[moatazezat]

can I sort without create years. 

[v-yuezhe-msft]

@cosminc ,

Could you please share the sample data and the expected result to us for analysis. According to your description, my understanding is that you want to sort the clustered bar chart ordered by a measure based on the max year. In this scenario, we can create the measure for each year, then sort the visual with the measure of max year. Please refer to the following steps:

1. We can create the measure for each year like below:

****2017 = CALCULATE(<Expression>,***[Year] = 2017)
****2018 = CALCULATE(<Expression>,***[Year] = 2018)
****2019 = CALCULATE(<Expression>,***[Year] = 2019)

2. Then drag the three measures to value.

3. Click the … on the Top right corner, select “Sort by”, select the measure of max year.


Regards,
Lydia