Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
can I sort without create years.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |