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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
SammyNed
Helper I
Helper I

Create a Filter based on a Slicer date

Hi everyone

 

Could i please get some assistance?

 

I have some dummy data below, in essence we have a users table, a user login table and a date table (relationships shown in the second snapshot). The users highlighted in yellow below are the users registered in the selected date range

SammyNed_2-1711527585253.png

SammyNed_0-1711528125530.png

 

 

The date table is used in the report as below. I want to add a filter/slicer to say if the user was registered during the selected filtered date or not. So a simple checkbox stating Yes or No (if the user was registered during the sliced date range)

SammyNed_2-1711528305089.png

 

Is this possible?

 

Thanking you in advance

Sammy

 

1 REPLY 1
Rupak_bi
Super User
Super User

Hi,

 

Try to create a measure : if(max(User,registration date)=selectedvalue(date table, date),"Yes","No"). Plot this measure in a Marix.



Regards
Rupak
FOLLOW ME : https://www.linkedin.com/in/rupaksar/

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.