Forum Discussion

Anonymous5's avatar
Anonymous5
Regular Visitor
6 years ago

Analyzing PO Performance

Hi all, I’m new to the community and new to Power BI. I am truly excited about the capabilities of this program for our company. My first attempt at using PBI will be to help our Procurement gro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous5 - Could you provide some sample data? 

Anonymous5's avatar
Anonymous5
Regular Visitor
6 years ago

Hi Nate,

 

Here's a sample of my query. Each row represents a PO created in 2019. The milestones occur along the way from it's preceding RFQ creation and approval through PO creation to receipt to delivery. I'd like my visualization to gather up all POs for a given quarter, average out the time spent at each phase and produce a horizontal stacked bar with 4 segments representing the following:

 

RFQ Creation - RFQ Aproval (days required)

RFQ Approval - PO Fiscal Effective Date (days required)

PO Fiscal Effective - PO Receipt (days required)

PO Receipt - PO Delivery (days required)

 

 

Thanks and Regards,

Rob

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous5 - Could you copy and paste the text? It makes it easier for us to use.

    Thanks!

    Nathan

    • Anonymous5's avatar
      Anonymous5
      Regular Visitor
      6 years ago

      Hi Nate,

       

      Which text are you referring to? All I've done so far is merge the tables using Excel Power Query and removed all the non-relevant columns for the sake of displaying here.

       

      Rob

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Sorry, I mean the text from Excel, instead of a screenshot. Then I can copy and paste that as a source in Power BI.