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 ...
aj1973
Community Champion
Community ChampionHi 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?
- aj1973
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.
