Forum Discussion
Issue using date slicer from dynamic table
If you click on the date slicer, you can add a field from the sales table or a measure to the "filters on this visual" part of the filters pane. Then filter it to all "is not blank". You can also hide that from the end users when it's published.
sanman that is interesting! It would depend on which field you did use to filter the date slicer, what was the date range of the new data, and what type of relationships are between all the tables.
I should mention another method to do it is to create a both directions relationship between Sales and Date tables. Sometimes this excludes more data than expected and is not an ideal solution.
There are no relations between the two tables. I just wanted to show two separate metrics on the dashboard using the same year slicer.
The both direction relationship worked. Thank you!