Forum Discussion
Cross Table Drill Through Filter
Hello All, I am trying to implement a drill through functionality between a time series plot on my Summary page and a matrix on corresponding summary pages. I will spare some details as I have some complex measures, tables and formulas that I do not think are relevant. Essentially, on the summary page, there is a time series plot with a Date field. When users drill through, they should have the date and function selected from the data point they drilled on. This works, as seen in the last image. I believe both variables are formatted as Dates (show 12:00:00 AM if a time is shown), but any attempt at filtering either keeps too many rows with other dates, keeps no rows, or fails to compile. Does anyone have a solution to this?
Pages:
Summary Page Time Series Plot:
CRM Page Matrix Visual:
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.
2 Replies
I 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.
