cancel
Showing results for
Did you mean:
Member

## Sorting a graph after values from max year

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

Moderator

## Re: Sorting a graph after values from max year

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.