Forum Discussion

Jan845's avatar
Jan845
Helper I
3 years ago

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: https://we.tl/t-RDu0S6WZ6L

 

Thank you for your time and help.