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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper I
Helper I

YTD Line Chart help

Hey guys,


Hope you are going well!


I have difficults to create a YTD Line Chart with my data, someone can help me? I need to create a chart YTD for my tickets from "PO" and "LX"


I have one collumn called "Etiquetas" that have many different data, so i need to count number of rows that have value "PO" and if the Type collumn the value = "Service Request"

This is my measure: 

CountNumberofTicketsPO =
CALCULATECOUNTROWS(FILTER(Table1, Table1[Tipo] = "Service Request" && Table1[Etiquetas] = "PO")))

I have other measure for count LX tickets 
CountNumberofTicketsLX =
CALCULATECOUNTROWS(FILTER(Table1, Table1[Tipo] = "Service Request" && Table1[Etiquetas] = "LX")))
I create two charts with this 2 measures and my collumn date "Hora de criação" .
I have two filters (Month and Year) how can i create a chart YTD with this 

My dashboard:

My PBIX file:


Thank you for your time and help.

Super User
Super User

@Jan845 Try: Better Year to Date Total - Microsoft Power BI Community

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

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