Forum Discussion
Cross Table Drill Through Filter
No, I was having trouble using the selected Date value from ErrorDateAxis to filter my matrix which uses the Bad Value Log datasource containing Run Date such that 'Bad Value Log'[Run Date] = 'ErrorDateAxis'[Date]. I realized I can add Date directly to the visualization-level filters of my matrix and have Select All selected since the dates are already filtered down in the drill through filters. Moreover, I did realized that I needed to switch the data type for 'ErrorDateAxis'[Date] from Date/Time to Date.
Super UserI am a bit confused on what you are asking
Are you asking how to convert a timestamp into a Date/Time ?
No, I was having trouble using the selected Date value from ErrorDateAxis to filter my matrix which uses the Bad Value Log datasource containing Run Date such that 'Bad Value Log'[Run Date] = 'ErrorDateAxis'[Date]. I realized I can add Date directly to the visualization-level filters of my matrix and have Select All selected since the dates are already filtered down in the drill through filters. Moreover, I did realized that I needed to switch the data type for 'ErrorDateAxis'[Date] from Date/Time to Date.