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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
machucam
New Member

Filter visual using checkbox

Hi,

 

I have a large table and I am trying to figure out a way to create a checkbox slicer in powerbi that when selected it will filter a table to show what was added to the table after a fixed date.  So what I'm trying to accomplish is allowing the users to see what has been recently added to the table.  So I update the data in the table once a quarter and say the last update was in August, 2024.  If you select the checkbox, you will now only see in the table what was added after Aug 2024.  I know I could just use a slider, but then the user would have to input the date.  I just want a simple checkbox which would be labeled, show new items since last update, and it would just show based on the date I input. 

1 ACCEPTED SOLUTION
bchager
Resolver III
Resolver III

@machucam Does this work for you? Adding a simple calculated column to return "Is Latest" for the MAX date, and using that in a slicer.

 

View solution in original post

2 REPLIES 2
bchager
Resolver III
Resolver III

@machucam Does this work for you? Adding a simple calculated column to return "Is Latest" for the MAX date, and using that in a slicer.

 

Thanks.  That was a good workaround. 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors