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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Vincent2000
New Member

One segment filter applied on two columns

Hello everyone,

 

I would like to have the possibility to display information from my data however a date (year) is present in at least one of two columns with date.

For exemple with the following table:

ProjectNameYear1Year2
Proj120232024
Proj220242024
Proj320232023
Proj420222023
Proj520222022

 

If my segment filter is set to "2023", my page display the table with the lines containing 2023 wherever it is in column "Year1" or "Year2" :

ProjectNameYear1Year2
Proj120232024
Proj320232023
Proj420222023

 

Do you have any idea ?

Thank you

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Vincent2000 

you can try this.

 

1. create a new table for filtering (do not create relationship with your fact table)

Table 2 = DISTINCT( union(DISTINCT('Table'[Year1]),DISTINCT('Table'[Year2])))
 
 

11.PNG

 

2. create a measure

Measure = if(max('Table'[Year1])=max('Table 2'[Year1]) || max('Table'[Year2])=max('Table 2'[Year1]),1)
 
then add this mesure to the visual filter and set to 1
 
12.PNG
 
pls see the attachment below




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@Vincent2000 

you can try this.

 

1. create a new table for filtering (do not create relationship with your fact table)

Table 2 = DISTINCT( union(DISTINCT('Table'[Year1]),DISTINCT('Table'[Year2])))
 
 

11.PNG

 

2. create a measure

Measure = if(max('Table'[Year1])=max('Table 2'[Year1]) || max('Table'[Year2])=max('Table 2'[Year1]),1)
 
then add this mesure to the visual filter and set to 1
 
12.PNG
 
pls see the attachment below




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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