Forum Discussion
Dynamic Date Headers
I created a table with dates that updates every week. I created a straight table where I list all the fields with icons (KPI). You will see the dates are ordered as the OrderID above....
Arrears Stage | KPI1 | 201908 | KPI2 | 202008 | 202007 | 201909 | KPI3 | 20200926 | KPI4 | 20200826 |
| Current | 0 | 10.00% | 1 | 1.00% | 2.00% | 1.00% | 0 | 2.00% | 1 | 1.00% |
| Cycle 1 | 0 | 30.00% | 1 | 40.00% | 30.00% | 30.00% | 0 | 30.00% | 1 | 20.00% |
| Cycle 2 | 0 | 60.00% | 1 | 50.00% | 50.00% | 50.00% | 0 | 50.00% | 1 | 50.00% |
| Cycle 3 | 0 | 80.00% | 1 | 70.00% | 50.00% | 55.00% | 0 | 60.00% | 1 | 40.00% |
| NPL | 1 | 5.00% | 0 | 4.00% | 5.00% | 1.00% | 1 | 3.00% | 0 | 3.00% |
| Total | 0 | 4.00% | 1 | 2.00% | 2.00% | 4.00% | 0 | 3.00% | 1 | 3.00% |
| 201908<202008 | 201908>202008 | 20200926<20200826 | 20200926>20200826 |
MFelix
Super User
Super UserHi Anonymous ,
Is the import of the information in the first format or the second one?
- MFelix
Hi Anonymous ,
I was abble to get a working solution working with unpivot and creating a middle step to get the column names and sort the information in the I also create some measure for condittional formatting be aware that this may needs some changes.
Check PBIX file attach, and experiment with other information wiht different dates.