Forum Discussion
Assigning a Date to a Calculated Column or Measure then Displyaing using a Clustered Column Chart
I need help with creating a Clustered Column Chart. I am a Power Bi novice (couple of months under my belt). The problem: I am working with sales data that is generated over multiple months (...
parry2k
Super User
Super UserYou explained well, but it will be nice to see some sample data to provide help.
Sure, I'm not sure how to upload an excel file, so here is a snapshot of the data I am working with:
| pickup_date | dropoff_date | 7 - Total Day Count | 6 - Daily Sales | C - January 2017 Day Count | C - February 2017 Day Count | M - January 2017 Sales | M - February 2017 Sales |
| 30/09/2016 | 6/02/2017 | 129 | $42.90 | 31 | 6 | $1,329.90 | $257.40 |
| 6/01/2017 | 30/03/2017 | 83 | $72.68 | 25 | 28 | $1,817.00 | $2,035.04 |
| 10/01/2017 | 27/03/2017 | 76 | $42.14 | 21 | 28 | $884.94 | $1,179.92 |
| 3/11/2016 | 7/01/2017 | 65 | $68.93 | 7 | $482.51 | ||
| 7/11/2016 | 4/01/2017 | 58 | $88.72 | 4 | $354.88 | ||
| 18/11/2016 | 13/01/2017 | 56 | $44.64 | 13 | $580.32 | ||
| 8/02/2017 | 27/03/2017 | 47 | $59.44 | 20 | $1,188.73 | ||
| 10/12/2016 | 24/01/2017 | 45 | $48.92 | 24 | $1,174.08 | ||
| 20/01/2017 | 3/03/2017 | 42 | $47.94 | 11 | 28 | $527.31 | $1,342.24 |
Dates are in NZ format, so the day and month are opposite to the US convention.
Cheers, Jonathan
Hi jonathan_nz,
It is hard to use measure or calculate column to modify the display graphic, perhaps you can try to write a measure to calculate the next month amount based on current month.
Regards,
Xiaoxin Sheng