Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My table structure is more or less as follows (projects)
Title Start date End date
Proj A 01.01.2018 31.12.2018
Proj B 01.01.2018 30.04.2019
Proj C 01.09.2018 31.01.2019
Now I would need to have a filter of the data by year (not the full date). In the above scenario, I need to be able to get "Proj B" and "Proj C" returned if I select either 2018 or 2019 as my filter/slicer.
Thanks for help!
Solved! Go to Solution.
HI @lkarolak,
Current power bi filter not works on multiple date column, you need to create a table to store expand detail date form date columns and filter on detail date.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
HI @lkarolak,
Current power bi filter not works on multiple date column, you need to create a table to store expand detail date form date columns and filter on detail date.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |