Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Dear Community
I have a problem that I need your help with.
Initial situation:
Table 1 = Contract data with 2 date columns (start and end)
Date table 1 = Simple date table with "ADDCOLUMNS" and
"CALENDAR" formula --> has a relation to "Start" in table 1
In the report, a slicer can be used to set the filter individually to the date table 1 with "Start".
However, I only want to display the values that are dependent on date table 1 but affect the "End" column.
= 8 months before MIN date and 2 months after MAX date
Problem
If I create an additional table and set the start and end date as a measure of date table 1, the calendar does not start with the selected filter.
How can I generate either a new table, a new column or a new filter that filters the end date?
The filter does not have to act on a measure, but on the entire report page.
Of course, the best thing would be if I could change the 8 months before and 2 months after with a slicer (per month).
Thx! 🙂
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
71 | |
68 | |
42 | |
42 |
User | Count |
---|---|
46 | |
40 | |
28 | |
27 | |
26 |