Forum Discussion
Visualizing Historical Data
Hi tom-lenzmeier ,
In my example, I used the IsCurrent flag in the table to determine the version. I added a column where IsCurrent = 1 is labeled as Version 1 (current record), and IsCurrent = 0 as Version 0 (historical record).
I also transformed the data in Power Query by unpivoting columns like StartDate, EndDate, CurrentPrice, and PriceValidFrom, so these attributes are displayed as rows.
For the matrix visual, I set:
Rows: Attributes
Columns: Version
Values: AttributeValue
I disabled row and column subtotals so only the values appear side by side in the matrix.
Since your table already uses the SCD Type 2 structure (StartDate, EndDate, IsCurrent) as described in the documentation, this approach should work for you as well.
If you need more details, just let me know.
Hi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Attributes Version 0 Version 1 Start Date 01/01/26 02/01/26 End Date 01/31/28 01/31/28 Current Price $101.00 $97.00 Current Price Valid From 01/01/26 02/01/26 I'm thinking of a multi-row card for the agreement number and contracting entity.
Hi,
Sorry but from this information, i cannotunderstand the result that you want to generate.
