The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi.
So I am facing this issue, and I have not seen it anywhere.
I basically have this table :
PR Number | Department | PR Status | Year | Vendor | Date | PR Raised by | PR Approved Date(LM) | PR Approved Date(Procurement) | SLA Met | Purchase Type | PR Order Creation Date |
PR0001 | Procurement | Open | 2024 | Vendor 1 | 19/06/2024 | John | 22/06/2024 | 22/07/2024 | No | RFP | 23/07/2024 |
PR0002 | Operations | Open | 2024 | Vendor 2 | 31/01/2024 | Alice | 03/02/2024 | 28/02/2024 | No | RFQ | 29/02/2024 |
PR0003 | Finance | Closed | 2024 | Vendor 3 | 01/02/2024 | Bob | 10/02/2024 | 10/03/2024 | No | Exception | 10/03/2024 |
PR0004 | Marketing | Closed | 2024 | Vendor 4 | 07/02/2024 | Carol | 15/02/2024 | 16/02/2024 | Yes | Exception | 18/02/2024 |
PR0005 | IT | Open | 2024 | Vendor 5 | 15/02/2024 | David | 18/02/2024 | 18/03/2024 | No | RFP | 19/03/2024 |
I have 3 durations, I would like to show:
1. Duration of days from Date to PR Approved Date (LM)
2. Duration of days from PR Approved Date (LM) to PR Approved Date (Procurement)
3. Duration of days from PR Approved Date (Procurement) to PR order Creation Date
I want to show these durations for each Purchase Type
Example: RFQ, RFP, and Exception.
So when I filter through Department or PR number, I can know what was all the 3 durations for each Purchase Type.
I want something like this:
I know I can recreate it bar chart or a matrix visual. But the issue I am facing is that, I have 3 durations for each Purchase Type.
That's why it's not coming the way I want it to.
Can you anyone suggest what I can do?
I did all that.
I have this formula
Closed should come after Procurement Approved.
I hope I am making sense.
and for duration, I have this formula.
What I am looking for is basically, for each PR Number, I need to see the duration days from LM Approved, Procurement Approved and PO Creation Date (Clsoed)
I don't need the dates. I need the duration days rather similar to a gantt chart. But not sure how to structure my table.
You can get that by summing the differences between From and To.
First step is to bring the data into a usable format
Project | Purchase Type | Interval type | From | To |
Then use custom visuals like Deneb to show multiple date ranges in the same bar chart.
I'm not too sure if I understand you.
Your data is not in a usable format. It is coming from Excel where wide tables with many columns are common. Power BI expects narrow tables with limited number of columns. Unpivot your data with the headers that I suggested, or your own choice of headers.
Then use Deneb to plot the data