Forum Discussion
Revenue Pipeline Charting
I need to visualize in a column chart the projected revenue over the next 24 months. I have data rows that include:
1. Project name
2. Start Date
3. End Date
4. Expected Revenue.
The x-axis would represent each month (time) and the y-axis the total revenue.
Hi gsherwin,
I'm not very sure the pipeline chart you mention, is this means line chart or column chart?
You can drag the date field to axis and Expected Revenue to value field, then add slicer to filter the next 24 months.
Notice: I use the "end date" to calculate the revenue.
Regards,
Xiaoxin Sheng
2 Replies
Hi Gsherwin
do you have a date table? In that case you can easily drag the date as X - Axis and the Revenue as Y - Axis with the Project name as legend.
If not you can find a manual e.g. https://community.powerbi.com/t5/Community-Blog/The-quot-only-quot-Power-BI-calendar-you-will-ever-need/ba-p/66397. Then you have to build a relationship between your dates and the start/end date.
KRFlorian
Hi gsherwin,
I'm not very sure the pipeline chart you mention, is this means line chart or column chart?
You can drag the date field to axis and Expected Revenue to value field, then add slicer to filter the next 24 months.
Notice: I use the "end date" to calculate the revenue.
Regards,
Xiaoxin Sheng
