cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cosminc Member
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

graph example.jpg

Thanks,

Cosmin

1 REPLY 1
Moderator v-yuezhe-msft
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.
2.png

 

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

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.