Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
137 | |
70 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |