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.
Hello everyone!
I have some issue with filtering on date.
When i try to filter the calculations in the table do not change according to the chosen timframe and even disappear.
The calculations in the visualized table are bulit from 2 fact tables that both are connected to dim_date table as well.
Do you have any suggestion to solve this?
Thanks
Solved! Go to Solution.
Hi, @Anonymous ;
I tested it, Since your Date type is Date type, and the From DateTime and OD_create_datetime columns are date /Time type, they cannot be filtered by slicer. The following method is recommended.
1.delete the relationship
2.create a flag.
flag = IF(MAX([From DateTime])<MAX('slicer'[Date])&&MAX([From DateTime])>=MIN('slicer'[Date]),1,0)
3.apply it into filter.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous ;
I tested it, Since your Date type is Date type, and the From DateTime and OD_create_datetime columns are date /Time type, they cannot be filtered by slicer. The following method is recommended.
1.delete the relationship
2.create a flag.
flag = IF(MAX([From DateTime])<MAX('slicer'[Date])&&MAX([From DateTime])>=MIN('slicer'[Date]),1,0)
3.apply it into filter.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi!
Thank you for your solution!!
Changing the format of the other 2 columns to date format made the filtering work even without creating the flag.
But still thank you, I'll keep in mind all your solution (with the flag).
Hi @Anonymous ,
Could you please share a screenshot of dates values from the 3 related dates columns so I know undestand what is happening in your file.
Did it work ? Mark it as a solution to help spreading knowledge.
A kudos would be appreciated
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |