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 Team,
I have sales data from 2015. I connected to SQL Server. I want to show particular chart running total of sales last 12 months as bar chart and previous year last 12 months Sales as line chart in monthwise.
Sample Data as below
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
FY18 | 100 | 200 | 250 | 300 | 350 | 400 | 500 | 600 | 760 | 800 | 900 | 1000 |
FY19 | 180 | 170 | 130 | 120 | 400 | 1800 | 900 | 1800 | 1700 | 1600 | 1500 | 1200 |
FY20 | 176 | 198 | 1991 | 90 | 198 | 88 | ||||||
LTM Sales | ||||||||||||
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
FY19 | 12500 | 16500 | 17500 | 17600 | 16540 | 12345 | 12345 | 176509 | 12345 | 17609 | 18698 | 12345 |
FY20 | 17654 | 17654 | 18765 | 16590 | 13153 | 11441 | ||||||
(Last 12 months running total) |
I want to show comparison of last 12 months sales running total vs previous year last 12 months sales as per below visual,
@Anonymous ,
Could you please share the sample table and give the expected result?
Regards,
Jimmy Tao
Hi,
Please find below sample data
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
FY18 | 100 | 200 | 250 | 300 | 350 | 400 | 500 | 600 | 760 | 800 | 900 | 1000 |
FY19 | 180 | 170 | 130 | 120 | 400 | 1800 | 900 | 1800 | 1700 | 1600 | 1500 | 1200 |
FY20 | 176 | 198 | 1991 | 90 | 198 | 88 | ||||||
Last12 Month sales RUNNING TOTAL | ||||||||||||
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
FY19 | 6240 | 6210 | 6090 | 5910 | 5960 | 7360 | 7760 | 8960 | 9900 | 11300 | 11500 | |
FY20 | 11496 | 13385 | 13355 | 13153 | 11441 | |||||||
May | Jun | Jul | Aug | Sep | ||||||||
FY20 | 11496 | 13385 | 13355 | 13153 | 11441 | |||||||
FY19 | 6240 | 6210 | 6090 | 5910 | 5960 |
|
Any solution?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |