Tricky column chart for sales pipeline data

[tom_89]

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

[Anonymous · Accepted solution]

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_89]

Thank you so much for your help, it works perfectly