I have two hopefully straight-forward questions about the attached pbix file, and its lone visualization.
- Can I - or how do I - modify the Date legend to remove the day from the date (ex. Sunday, November 1, 2020)?
- I’d like to stack the “Booked Sales estimated to ship by end of month” on top of the Billed Sales Running Total for the date on which both occur (November 20). Keeping a clear distinction of the two measures while portraying their sum is the objective (in order to compare to an end of month forecast). How can I accomplish it?
I’m open to any improvements to [or best practices for] the visualization which compares sales to date with planned and forecast amounts, with projected (estimated) sales for the remainder of the month.
Enterprise Sales Reporting example.pbix (41.6 KB)