Forum Discussion

cosminc's avatar
cosminc
Post Partisan
7 years ago

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

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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