Hey guys probably an obvious answer here but i cant seem to make it work i am running a table similar to the below in power bi visuals Date CAS CAS Average Duration CAS Total Expected Effort RUD RUD Average Duration RUD Total Expected Effort 01/01 45 01:15 0:56:14 51 01:15 1:03:43 04/01 109 01:10 2:07:37 98 01:59 3:14:59 05/01 107 01:08 2:00:16 93 01:48 2:47:29 06/01 103 01:01 1:45:24 94 01:44 2:42:50 07/01 94 01:12 1:53:10 84 01:58 2:45:10 08/01 100 01:09 1:54:10 88 01:57 2:51:47 CAS and RUD are departments, what i have done is taken a year of this data and graphed them in a line graph, however i want to be able with a click of a visual button toggle RUD/CAS data on and off when i build a slicer it shows me every day as a selection which is not want i want, essentially i want to filter based on the headers above ( or a selection of them ) Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Button filters / slicer on graph

Thread starter mikenz1983
Start date Jan 26, 2021

mikenz1983

New Member

Jan 26, 2021

Hey guys

probably an obvious answer here but i cant seem to make it work
i am running a table similar to the below in power bi visuals

Date	CAS	CAS Average Duration	CAS Total Expected Effort	RUD	RUD Average Duration	RUD Total Expected Effort
01/01	45	01:15	0:56:14	51	01:15	1:03:43
04/01	109	01:10	2:07:37	98	01:59	3:14:59
05/01	107	01:08	2:00:16	93	01:48	2:47:29
06/01	103	01:01	1:45:24	94	01:44	2:42:50
07/01	94	01:12	1:53:10	84	01:58	2:45:10
08/01	100	01:09	1:54:10	88	01:57	2:51:47

CAS and RUD are departments, what i have done is taken a year of this data and graphed them in a line graph, however i want to be able with a click of a visual button toggle RUD/CAS data on and off

when i build a slicer it shows me every day as a selection which is not want i want, essentially i want to filter based on the headers above ( or a selection of them )

Thanks