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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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