Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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:
ProjectName | Year1 | Year2 |
Proj1 | 2023 | 2024 |
Proj2 | 2024 | 2024 |
Proj3 | 2023 | 2023 |
Proj4 | 2022 | 2023 |
Proj5 | 2022 | 2022 |
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" :
ProjectName | Year1 | Year2 |
Proj1 | 2023 | 2024 |
Proj3 | 2023 | 2023 |
Proj4 | 2022 | 2023 |
Do you have any idea ?
Thank you
Solved! Go to Solution.
you can try this.
1. create a new table for filtering (do not create relationship with your fact table)
2. create a measure
Proud to be a Super User!
you can try this.
1. create a new table for filtering (do not create relationship with your fact table)
2. create a measure
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |