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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
testtestington
New Member

Date filters with simple measures

I am a new user to PowerBI and I'm having trouble determining how I should be applying date filters. 

 

I have a table of ticket data where the status of tickets are recorded, including fields such as the status of the ticket and the close time. 

 

My measures include counting the number of tickets submitted, completed etc. I would also like to include a visualisation of tickets completed by type and user. Example:

 

view.png

 

My issues are the following:

1. How do I utilise Calendar by Tallan such it displays the current month in days and allow me to navigate to previous months/years?
2. How do I link the Calendar such that when a date is selected, a date filter is applied bespoke to all measures on the page? For example, if I select 10 Jan 19 in the Calendar, the number of closed tickets shown are those with a closetime value of 10 Jan 19. For open tickets, those shown are those with a logtime value of 10 Jan 19. 

3. I would also like to create a line graph of total tickets (not shown in the image). How do I apply date dimensions such that the data points are on a per day basis, but the axis lables cover the relevant months only (May 18, Jun 18, Jul 18 etc.)? Additionally, I would like these data points to ignore weekend and defined holiday dates. 

 

Thank you in advance

 

**EDIT** additional point regarding point 3

2 REPLIES 2
adambhappy
Resolver II
Resolver II

Can you share the data structure? I.e. the tables within the PBIX and the relationships you have currently applied.

I only have one table, similar to the following:

table.PNG

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors