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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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


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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.