Forum Discussion
Help to create a year to date chart
Hi guys,
I have this chart that counts total quests in this location.
My date filter is one collumn in date and time with name "Hora de criação" and i have year and month to filter.
And i have the filter month of year
My measure to count total of tickets
PedVS = calculate(counta('Table1'[Etiquetas]),Filter('Table1', SEARCH ("VS" ,Table1[Etiquetas])
If i have VS that counts 1 to number requests.
How can i add a chart year to date with filter month ?
Thank you for all help.
1 Reply
I'd consider using the CALENDAR function and joining it to your existing dataset.
https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tablesOnce you've done that then you can filter by relative time/date in the 'Report View'.
