Forum Discussion

tom_89's avatar
tom_89
New Member
9 years ago
Solved

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:

 

StageJan '17Feb '17Mar '17
1. Target121
2. Bid232
3. Finalist455
4. Won123

 

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's avatar
    Anonymous
    9 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

  • Anonymous's avatar
    Anonymous
    Not 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_89's avatar
      tom_89
      New Member

      Thank you so much for your help, it works perfectly :smileyhappy: