Help Needed: Creating Custom Timeframe Filter Dropdown in Power BI

Question

Hi there,I'm currently working in Power BI and I'm looking to create a filter dropdown with specific timeframe options. These options include:Currently OpenTotal HistoricalYear-to-Date (YTD)Last 3 MonthsLast 6 MonthsI've attempted to use the relative date setting, but it doesn't quite meet my requirements. I aim to create a filter similar to the image attached, where instead of the year, it will display the aforementioned timeframes. Additionally, I want this filter to apply to all graphs accordingly.Any insights or guidance on achieving this would be greatly appreciated. Thank you!Here is the sample of the data.&nbsp;&nbsp;Status CodeClaim GroupClaim RepresentativeDate MailedTotal AmountopenFirst 30 daysDallon Codner02/18/202416670.02outstandingFirst 30 daysDallon Codner02/18/202413301.2outstandingApproved to be paidDallon Codner12/25/202321002.53outstandingApproved to be paidDallon Codner12/25/202320179.82outstandingApproved to be paidDallon Codner02/18/20241060.81openFirst 30 daysDallon Codner12/25/202313465.73openApproved to be paidDallon Codner12/25/202319096.97openFirst 30 daysDallon Codner02/18/20241448.96openApproved to be paidDallon Codner12/25/202319746.26outstandingFirst 30 daysDallon Codner12/25/20237335.63openFirst 30 daysDallon Codner02/18/202418120.05openApproved to be paidDallon Codner02/18/20245648.41outstandingFirst 30 daysDallon Codner02/18/20248737.64&nbsp;&nbsp;Let me know if there is anything else I need to add or provide.

ritaf1983 · Accepted Answer

Hi&nbsp;gkeo22&nbsp;Please refer to the linked tutorial:
https://www.youtube.com/watch?v=fKygF7VEJnQ
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
&nbsp;

Forum Discussion

Help Needed: Creating Custom Timeframe Filter Dropdown in Power BI

1 Reply

Related content

Dropdown Slicer

Slicer Dropdown

Destination Connection dropdown changed

Creating relationships

Creating ICMs via Activator

Status Code	Claim Group	Claim Representative	Date Mailed	Total Amount
open	First 30 days	Dallon Codner	02/18/2024	16670.02
outstanding	First 30 days	Dallon Codner	02/18/2024	13301.2
outstanding	Approved to be paid	Dallon Codner	12/25/2023	21002.53
outstanding	Approved to be paid	Dallon Codner	12/25/2023	20179.82
outstanding	Approved to be paid	Dallon Codner	02/18/2024	1060.81
open	First 30 days	Dallon Codner	12/25/2023	13465.73
open	Approved to be paid	Dallon Codner	12/25/2023	19096.97
open	First 30 days	Dallon Codner	02/18/2024	1448.96
open	Approved to be paid	Dallon Codner	12/25/2023	19746.26
outstanding	First 30 days	Dallon Codner	12/25/2023	7335.63
open	First 30 days	Dallon Codner	02/18/2024	18120.05
open	Approved to be paid	Dallon Codner	02/18/2024	5648.41
outstanding	First 30 days	Dallon Codner	02/18/2024	8737.64