What is the best way to create a monthly trend line over a columns chart?

[TPista]

I have my columns chart which displays several security KPIs, all of them are percentages. I want to set a separate trend line on each one of them. Please refer to the following image:

These are 4 KPIs, all saved in the same table. Each percentage represents a value at a given month. Light blue for january, dark blue for february and orange for march.

This is the data im using for this report:

Where:

ENE-24 are the percentages of all kpis for the month of january

FEB-24 are the percentages of all kpis for the month of february

MAR-24 are the percentages of all kpis for the month of march

Indicadores are all the KPI names.

Do I need to create a measure on power bi or in the data sheet (excel) where im extracting the values?

Ideally this is how it should look like:

Thank you in advance

[CMajka8]

Yes, indeed. Ed's method in the linked blog is the best method I have come across. It's easy to implement and dynamic. Hope it helps

https://www.ehansalytics.com/blog/2019/3/17/create-a-dynamic-date-table-in-power-query

[CMajka8]

I would consider using small multiples here so that the time [month] can be on the X axis. You will probably want to create a proper date table as well, if you don't have one already. 

[TPista]

Hi, thank you for your reply.

Do you have any resources that I can check in order to understand how to create a proper date table for this case?