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.
I have a date slicer and a trend chart. My trend chart shows data even if that falls beyond the date range. Why is that?
Solved! Go to Solution.
Hey @tvaishnav !
Is the 'Post Date' used in the slicer the same date used on the x-axis in the graph? Is the 'Post Date' in a separate table than the date used on the x-axis in the graph?
Can you post sample data or a screenshot of your field & visualization wells?
hi, @tvaishnav
Please check:
If "Post Date" and "Payroll End Date" are the same date
or create the relationship by them? and if the cross filter direction should be "Both".
If not your case, please share your sample pbix file for us to have a test.
Best Regards,
Lin
Hey @tvaishnav !
Is the 'Post Date' used in the slicer the same date used on the x-axis in the graph? Is the 'Post Date' in a separate table than the date used on the x-axis in the graph?
Can you post sample data or a screenshot of your field & visualization wells?
I was using two different date fields one for slicer and another for visual. Putting the same field on both silcer and visual solved the problem.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |