Forum Discussion
Jan845
3 years agoHelper 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 =
CALCULATE( COUNTROWS(FILTER(Table1, Table1[Tipo] = "Service Request" && Table1[Etiquetas] = "PO")))
I have other measure for count LX tickets
I have other measure for count LX tickets
CountNumberofTicketsLX =
CALCULATE( COUNTROWS(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 dashboard:
1 Reply
- Greg_DecklerCommunity Champion