How to display my visual with SCD Type 2 data

[Nissa23]

Hi,

I've done many reaserch before asking my problem here.

I've built my report with a first version where I don't have changes in my dimension table. 

Now, I need to change it in order to take in account the slowly changing dimension. 

I've created 3 new columns : start_date and end_date, and a 'Current' column with values : 0,1.

I want in my report to keep the historical visualisation. I don't know how to do it?

Can anyone help me with an idea?

Thanks

[Anonymous]

Hi @Nissa23 ,

For a more detailed guide to using SCD Type 2 in Power BI, including how to properly set up models and visual objects, I recommend reviewing the following documentation:

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

Best Regards,
Adamk Kong