Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi
i have an issue with a table with column Year,MonthNumber, Salesman and Sales
and i want to obtain a bar graph with top 10 salesman (after sales of maxyear YTD) - with 3 bars for yeach sales man - maxyear ytd, maxyear-1 ytd and maxyear-2 ytd
top 10 saleman after maxyear ytd
as ex the results have to be: list top 10 salesmen from 2019 sorted after sales and each have three bars - up 2019 jan, middle 2018 jan and bellow 2017 jan (for the data till jan 2019)
Thanks,
Cosmin
Hi @cosminc
Can you show some sample data and your expected result based on that? Otherwise it's a bit hard to help.
Please show your sample data in text-tabular format in addition to (or instead of) the screen captures. That allows people trying to help to readily copy the data and run a quick test. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).
Hi,
Thanks for your help
table is like this but multiply with oher names on salesman column; see also the graph
i need 2 graphs:
1. year to date - 2019,2018 (not full, variable till maxmonth from maxyear) & 2017 (idem) bars (the years have to be obtained as maxyear and labeled as they are..2019,2018,2017, because is a dinamyc base); sorted years bars in this order and top 10 salesman after ytd data from 2019
2. monthly - last month data (max year-month), previous month and same month last year; same principle
many thanks,
Cosmin
Year | MonthNo | Salesman | Sales |
2019 | 1 | George | 80 |
2018 | 1 | George | 62 |
2018 | 2 | George | 74 |
2018 | 3 | George | 49 |
2018 | 4 | George | 28 |
2018 | 5 | George | 51 |
2018 | 6 | George | 73 |
2018 | 7 | George | 53 |
2018 | 8 | George | 75 |
2018 | 9 | George | 30 |
2018 | 10 | George | 98 |
2018 | 11 | George | 22 |
2018 | 12 | George | 97 |
2017 | 1 | George | 20 |
2017 | 2 | George | 42 |
2017 | 3 | George | 57 |
2017 | 4 | George | 24 |
2017 | 5 | George | 27 |
2017 | 6 | George | 41 |
2017 | 7 | George | 46 |
2017 | 8 | George | 19 |
2017 | 9 | George | 63 |
2017 | 10 | George | 28 |
2017 | 11 | George | 85 |
2017 | 12 | George | 74 |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |