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 ...
Hi jmadsen
That depends on what column Date you put into the slicer. You have too many columns date and each column or each date correspond to their specific data.
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?
It'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.