How to configure Dashboard slicers to work with Tabulate slicers?
I have a tabulate that contains 2 discovers, both filtered by a date. I grab one of the rows from the second discover and place it at the bottom of the first sheet and create some calcs.
Here is a simplified example:
Rows 1-5 are from Discover 1
Row 6 is a simple Sum Total
Row 7 is coming from Discover 2 on sheet2
Row 8 is Row 6 divided by Row 7
This part is working as expected. I can change the slicer and it returns the correct data. The problem is when I drop it in a dashboard. The slicer in the dashboard, which I pulled from the Tabulate, is not changing the data even though the breadcrumb is showing that the value is being passed in. I’m sure it is something I missed in configuring either the slicer in Tabulate or the Visual Area. Do I need to create parameters? Should I not include a slicer in the tabulate? How do I get the dashboard and tabulate to communicate?