Thank you for your patience, beginner user in Power Bi:
Data Source format excel file
My data set has Unique identifiers for each KPIs and four (4) columns per quarter – each quarter is defined by the last date of the reporting period.
KPI Ref. | KPI Description | Q1 Target | Q1 Actual | Q1 Status | Q1 Comments |
Q2 Target
| Q2 Actual | Q2 Status | Q2 Comments | Q3 Target | Q3 Actual | Q3 Status | Q3 Comments | Q4 Target | Q3 Actual | Q4 Status | Q4 Comments |
AM.0001.1 | Group established and maintained to drive system improvements | 50% | 50% | On Target | Stakeholders Identified | 75% | 75% | On Target | TOR Established | 100% | 100% | On Target | Group Established & Positions appointed | 100% | 100% | On Target | Second meeting held. Submitted 3 improvement project BCs up for consideration |
Filter will be created using: Q1 31/3/2024, Q2 31/12/2024, Q3 31/3/2025 & Q4 30/6/2025
The objective is to return the applicable 4 columns for each quarter within a table/visual after the filter Q1,Q2,Q3 or Q4 selection has been made.
Example Option 1 : test file is a combination of 4 individual files that have been used during each quarter to update progress of the KPI
resulting in there being 1288 rows contaning KPI being counted as opposed to the 322 for the year.
Example Option 2 : test file is one file source overwritten at the end of each quarter a total of 322 KPIs for the year
Is there DAX code that might be able to display specific columns realting to the target, actual, status and comments isolated out to the quarter being selected?
I can't seem to find what I require in Google and YouTube searches only findign a summary of the values which is not relevant in this case.
Thank you in advance
Ange M
