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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Jan845
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:
Jan845_0-1680124255508.png

My PBIX file: https://we.tl/t-RDu0S6WZ6L

 

Thank you for your time and help.

1 REPLY 1
Greg_Deckler
Super User
Super User

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


@ 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

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.