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.
Hi All,
I have 2 slicers in my report, 1 slicer having custom period value and another slicer is having date with between format as given below.
Now, the issue is that based on custom date range selection, the other slicer value is not changing but it works fine if I change the slicer format to vertical list or dropdown.
Hi Charbel,
If you encountered the similar issue, can you kindly assist me with the solution?
Hello,
Can you check the interaction if is is set to interact in both direction
Hi Charbel,
Yes, it is set to interact in both direction.
Hi
the 2 slicers are using the same column, if not can you show us the model or at least the relation between the 2 tables
Both tables have one to may relationship with filter in both direction as shown below.
The specialDates table is a calculated table derived from date table.
Ok
one more thing to verify
the data in both columns have the same type
and both have a full date
Yes, both the date columns are of same type in dd-mm-yyyy format.
The format is not the type can you post a screen of both date columns as ai had the same problem before
PFA below screenshot.
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 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |