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.
Solved! Go to Solution.
I have made a seperate date table using the CALANDER() function, that isn't related to the rest of my dataset. I then have the slicer select dates from that independent date table, to filter the visual. The measure in the visual retrieves the selected date, and then uses it to filter the actual dates that are in the dataset - which themselves are not filtered by the slicer.
However, this filter doesn't seem to be behaving correctly.
The filter argument in:
I have made a seperate date table using the CALANDER() function, that isn't related to the rest of my dataset. I then have the slicer select dates from that independent date table, to filter the visual. The measure in the visual retrieves the selected date, and then uses it to filter the actual dates that are in the dataset - which themselves are not filtered by the slicer.
However, this filter doesn't seem to be behaving correctly.
The filter argument in:
I've realised that the reason it can't do the date comparison is because the tables are not related. This is such a catch-22.
There's the possibility of creating an inactive relationship, and then using the following code to activate it:
USERELATIONSHIP(Sheet1[Period - month], 'Independent Date Table'[Date])
However I can't seem to shuffle the code around in just the right way to make it work.
Anyway, since, in a way, I've solved the first part, I'll change the title of the post and mark this as solved and make a seperate post about the second part.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |