Forum Discussion
Tricky column chart for sales pipeline data
Hi there!
Like many sales pipelines, my company's system works by grouping sales opportunities into different "stages" according to their progress through the sales process - e.g. 1. Target, 2. Bid, 3. Finalist, 4. Won
I need to be able to create a chart which will show the number of opportunities in each stage within a given month, over the course of one year. Example dataset is here:
| Stage | Jan '17 | Feb '17 | Mar '17 |
| 1. Target | 1 | 2 | 1 |
| 2. Bid | 2 | 3 | 2 |
| 3. Finalist | 4 | 5 | 5 |
| 4. Won | 1 | 2 | 3 |
I think a stacked column chart would work here, with each stage being a portion of the column for a particular month - however, I can't figure out how to make it work in Power BI Desktop.
Any help would be amazing, thank you all very much
- Anonymous9 years ago
Hi
you can unpivot your dataset and can easy the process. Use Query Editor and use unpivot transformation.
Let me know if this is not satisfied your requirement.
Thanks
2 Replies
- AnonymousNot applicable
Hi
you can unpivot your dataset and can easy the process. Use Query Editor and use unpivot transformation.
Let me know if this is not satisfied your requirement.
Thanks
- tom_89New Member
Thank you so much for your help, it works perfectly :smileyhappy: