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.
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.
Solved! Go to Solution.
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
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
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-n.... Then you have to build a relationship between your dates and the start/end date.
KR
Florian
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 |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |