Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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

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:



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


Helper I
Helper I

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

Helper I
Helper I

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. 

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? 

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors