Hello,
I have a dashboard made up of slicers and charts connected to several pivots table to drill up and down..
They have the same data source and the "Data" and pivot sheets are hidden.
My next aim is to display the data (10 columns) based on the slicer selections at the bottom of the dashboard or in "Dashboard Data" tab.
I have converted my data sheet into a table but the dashboard slicers and table slicers can't connect because pivoted data is stored in the cache.
Can that approach be done in different way?
Thanks.
I have a dashboard made up of slicers and charts connected to several pivots table to drill up and down..
They have the same data source and the "Data" and pivot sheets are hidden.
My next aim is to display the data (10 columns) based on the slicer selections at the bottom of the dashboard or in "Dashboard Data" tab.
I have converted my data sheet into a table but the dashboard slicers and table slicers can't connect because pivoted data is stored in the cache.
Can that approach be done in different way?
Thanks.
