Dear All,
I am new in building dashboard and previously I have posted in Udemy seeking help for interactive slicers for dashboard.
While trying out the interactive slicers in my own dashboard, instead of selecting months/dates to control, I used time (1 minute interval - 1441 rows of data) to control the slicers. The slicers works but it does not fit in nicely into my dashboard. When i select - options- columns - "1" while inserting my slicers into my dashboard, it could not fit nicely into my dashboard. The slicers expand all the the way to the right side. Is there any way of making it fit nicely into my dashboard?
I am trying to achieve a slicer that can control a range but in higher interval. Hope you advise on it.
Here is my sample excel which i did and hope you can understand by what i describe:
https://drive.google.com/open?id=1tGW8GNgxntc08Ch8eqJbPi9VnkdFH-gH
Best Regards,
Chong
Hi Chong,
Unfortunately you can't group the times into intervals using the PivotTable Group setting.
If you want to filter by time intervals then you need to add a field to your BTU data that assigns the times in column A to the interval, or extract the minute as a whole number and then use the PivotTable Group setting on that field.
You can then use the Interval field as a Slicer. See sample file attached. Note: you will have to set up a custom list to sort the Slicer in numeric order.
Mynda