Forum Discussion
Date Slicer for Data Table from Multiple Sources
I have a report that brings in multiple queries from a SQL database, then brings puts them into a simple table. I'm trying to add a date slicer to the report. The queries only go back 90 days from ...
Amine,
That's why I created the calendar, linked them to my data, and only put the calendar date into the slicer field.
Is there a better way to do it?
aj1973
Community Champion
Community ChampionIt's a good thing you have created a Calendar, I didn't mean otherwise.
In order to display data that apply for each Column date in the Master Table you need to create measures for using USERELATIONSHIP() function.