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 guys
Monthly budget sales is on 1st day of the month.
Actual sales come in on every weekdays.
I try to build a bar chart, comparing actual daily sales to budget. with 2 filters: brand & sub brand.
It will look like this.
Period Brand Sub Brand Budget
1-Jan | A | A1 | 500 |
1-Feb | A | A1 | 500 |
1-Mar | A | A2 | 500 |
1-Apr | A | A2 | 500 |
1-May | A | A2 | 600 |
1-Jun | A | A2 | 700 |
1-Jul | A | A2 | 700 |
1-Aug | A | A2 | 700 |
1-Sep | A | A3 | 700 |
1-Oct | A | A3 | 900 |
1-Nov | A | A3 | 900 |
1-Dec | A | A3 | 900 |
1-Jan | B | B1 | 900 |
1-Feb | B | B1 | 400 |
1-Mar | B | B1 | 400 |
1-Apr | B | B1 | 400 |
1-May | B | B2 | 400 |
1-Jun | B | B2 | 400 |
1-Jul | B | B2 | 550 |
1-Aug | B | B2 | 550 |
1-Sep | B | B2 | 550 |
1-Oct | B | B3 | 550 |
1-Nov | B | B3 | 550 |
1-Dec | B | B3 | 360 |
1-Jan | C | C1 | 360 |
1-Feb | C | C1 | 360 |
1-Mar | C | C1 | 360 |
1-Apr | C | C1 | 360 |
1-May | C | C2 | 360 |
1-Jun | C | C2 | 420 |
1-Jul | C | C2 | 420 |
1-Aug | C | C2 | 420 |
1-Sep | C | C3 | 420 |
1-Oct | C | C3 | 420 |
1-Nov | C | C3 | 420 |
1-Dec | C | C3 | 420 |
Solved! Go to Solution.
Do you have the monthly budget brand and sub brand-wise?
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |