{"id":20685,"date":"2018-07-30T03:30:14","date_gmt":"2018-07-30T03:30:14","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=20685"},"modified":"2020-06-25T21:10:33","modified_gmt":"2020-06-25T15:40:33","slug":"power-bi-filter","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/","title":{"rendered":"Understand Power BI Filters to take your business to next level!"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1853,&quot;href&quot;:&quot;https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Order-details.zip&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251210052312\\\/https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Order-details.zip&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 10:07:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-13 23:45:42&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-17 08:20:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-20 08:55:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-23 10:08:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-26 13:20:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-30 07:11:50&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-03 03:33:21&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-06 06:55:33&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-09 09:00:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-12 10:41:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-15 16:40:18&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-19 03:52:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 03:55:40&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 11:15:29&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-29 05:31:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 14:13:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 15:59:03&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-07 16:38:25&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-11 04:07:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-14 21:01:45&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-18 01:46:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-21 11:58:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-24 13:19:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-27 14:25:21&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-03 12:48:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-06 20:25:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-10 02:42:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-13 03:33:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-16 09:04:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-19 10:47:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-22 12:01:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 13:42:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-29 14:53:21&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-02 10:57:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-05 11:19:35&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-09 06:08:35&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-12 10:19:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-15 17:03:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-18 18:57:50&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-22 00:36:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-25 09:11:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-28 09:48:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-01 17:20:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 22:39:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-08 06:10:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-11 07:21:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-14 08:09:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-17 20:37:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-21 06:25:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-25 03:32:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-28 07:13:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-31 08:36:07&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-06-03 10:49:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-06 16:56:41&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-10 03:27:36&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403}],&quot;broken&quot;:true,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:1854,&quot;href&quot;:&quot;https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Sales-details.zip&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251210052309\\\/https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Sales-details.zip&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 10:07:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-13 23:45:42&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-17 14:46:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-22 06:51:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 14:37:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-28 21:01:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-01 03:46:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-04 04:49:26&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-07 13:16:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-11 12:44:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 19:17:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-19 03:52:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 03:55:40&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 11:15:29&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-29 05:31:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 14:13:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 15:59:03&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-07 16:38:25&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-11 04:07:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-14 21:01:45&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-18 01:46:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-21 11:58:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-24 13:19:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-27 14:25:21&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-03 12:48:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-06 20:25:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-10 02:42:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-13 03:33:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-16 09:04:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-19 10:47:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-22 12:01:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 13:42:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-29 14:53:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-02 10:57:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-05 11:19:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-09 06:08:35&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-12 10:19:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-15 17:03:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-18 18:57:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-22 00:36:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-25 09:11:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-28 09:48:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-01 17:20:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 22:39:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-08 06:10:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-11 07:21:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-14 08:09:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-17 20:37:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-21 06:25:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-25 03:32:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-28 07:13:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-31 08:36:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-03 10:49:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-06 16:56:40&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-10 03:27:36&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403}],&quot;broken&quot;:true,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:1855,&quot;href&quot;:&quot;https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Customer-details.zip&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251210052317\\\/https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Customer-details.zip&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 10:07:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-13 23:45:42&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-17 14:46:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-22 06:51:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 14:37:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-28 21:01:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-01 03:46:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-04 04:49:26&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-07 13:16:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-11 12:44:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 19:17:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-19 03:52:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 03:55:40&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 11:15:29&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-29 05:31:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 14:13:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 15:59:03&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-07 16:38:25&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-11 04:07:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-14 21:01:45&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-18 01:46:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-21 11:58:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-24 13:19:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-27 14:25:21&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-03 12:48:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-06 20:25:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-10 02:42:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-13 03:33:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-16 09:04:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-19 10:47:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-22 12:01:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 13:42:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-29 14:53:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-02 10:57:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-05 11:19:35&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-09 06:08:35&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-12 10:19:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-15 17:03:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-18 18:57:50&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-22 00:36:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-25 09:11:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-28 09:48:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-01 17:20:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 22:39:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-08 06:10:02&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-11 07:21:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-14 08:09:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-17 20:37:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-21 06:25:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-25 03:32:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-28 07:13:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-31 08:36:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-03 10:49:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-06 16:56:41&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-10 03:27:36&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403}],&quot;broken&quot;:true,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:1856,&quot;href&quot;:&quot;https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Region-details.zip&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251210053854\\\/https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Region-details.zip&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 10:07:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-13 23:45:42&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-17 14:46:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-22 06:51:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 14:37:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-28 21:01:04&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-01 03:46:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-04 04:49:26&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-07 13:16:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-11 12:44:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 19:17:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-19 03:52:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 03:55:40&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 11:15:29&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-29 05:31:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 14:13:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 15:59:03&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-07 16:38:26&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-11 04:07:29&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-14 21:01:47&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-18 01:46:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-21 11:58:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-24 13:19:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-27 14:25:21&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-03 12:48:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-06 20:25:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-10 02:42:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-13 03:33:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-16 09:04:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-19 10:47:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-22 12:01:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 13:42:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-29 14:53:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-02 10:57:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-05 11:19:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-09 06:08:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-12 10:19:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-15 17:03:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-18 18:57:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-22 00:36:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-25 09:11:15&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-28 09:48:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-01 17:20:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 22:39:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-08 06:10:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-11 07:21:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-14 08:09:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-17 20:37:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-21 06:25:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-25 03:32:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-28 07:13:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-31 08:36:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-03 10:49:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-06 16:56:41&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-10 03:27:41&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403}],&quot;broken&quot;:true,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:1857,&quot;href&quot;:&quot;https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Product-details.zip&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251210053856\\\/https:\\\/\\\/data-flair.s3.ap-south-1.amazonaws.com\\\/Tableau-data\\\/Product-details.zip&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 10:07:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-13 23:45:42&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-17 14:46:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-22 06:51:05&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 14:37:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-28 21:01:03&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-01 03:46:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-04 04:49:26&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-07 13:16:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-11 12:44:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 19:17:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-19 03:52:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 03:55:40&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 11:15:29&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-29 05:31:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 14:13:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 15:59:03&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-07 16:38:25&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-11 04:07:29&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-14 21:01:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-18 01:46:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-21 11:58:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-24 13:19:45&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-27 14:25:21&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-03 12:48:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-06 20:25:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-10 02:42:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-13 03:33:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-16 09:04:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-19 10:47:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-22 12:01:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 13:42:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-29 14:53:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-02 10:57:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-05 11:19:35&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-09 06:08:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-12 10:19:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-15 17:03:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-18 18:57:50&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-22 00:36:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-25 09:11:16&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-28 09:48:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-01 17:20:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-04 22:39:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-08 06:10:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-11 07:21:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-14 08:09:44&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-17 20:37:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-21 06:25:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-25 03:32:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-28 07:13:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-31 08:36:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-03 10:49:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-06 16:56:41&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-10 03:27:36&quot;,&quot;http_code&quot;:403},{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403}],&quot;broken&quot;:true,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-13 03:45:32&quot;,&quot;http_code&quot;:403},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:1858,&quot;href&quot;:&quot;https:\\\/\\\/powerbi.microsoft.com\\\/en-us\\\/get-started&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20210421061838\\\/https:\\\/\\\/powerbi.microsoft.com\\\/en-us\\\/get-started\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 05:23:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-26 13:20:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-30 07:12:05&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-09 00:29:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-14 19:18:25&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-21 12:21:28&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-01-29 05:31:49&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-01 20:28:52&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-11 17:49:02&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-16 06:48:15&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-22 20:55:19&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-27 15:26:04&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-09 07:52:28&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-12 15:28:20&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-17 17:16:51&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-02 09:54:34&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-06 22:48:06&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-10 14:29:25&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-13 19:35:34&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-21 05:36:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-25 09:12:26&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-29 21:24:57&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-05 05:08:55&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-05-13 16:24:48&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-05-19 15:33:01&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-05-27 03:38:20&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-06-05 00:11:37&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-06-09 11:32:18&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-06-14 06:01:39&quot;,&quot;http_code&quot;:404}],&quot;broken&quot;:true,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-14 06:01:39&quot;,&quot;http_code&quot;:404},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p>After gaining basic knowledge of Power BI, let&#8217;s move on to the role of filters in Power BI reports and dashboards. Along with the theoretical knowledge, we\u2019ll also learn how to apply and use these filters in Power BI dashboards and reports.<\/p>\n<h2>What are Power BI Filters?<\/h2>\n<p>Filters in Power BI sort data and information based on some selected criteria. That is, you can select particular fields or values within fields and view only the information related to that. For instance, you have a dataset related to sales of a store. Now, using the filters you can filter out the unnecessary information. You can view a report having only the data for the selected aspects. Let\u2019s say, you only want to see the information on sales in India in the year 2019. For this, all you have to do is to put the filtering criterion as 2019 and India from their respective fields. The report of sales will immediately make changes accordingly and only show the graphs and visuals specific to sales statistics in India and in the year 2019.<\/p>\n<h3>Download Datasets<\/h3>\n<p>In this Power BI filters tutorial, we will be using the following datasets:<\/p>\n<ul>\n<li><a href=\"https:\/\/data-flair.s3.ap-south-1.amazonaws.com\/Tableau-data\/Order-details.zip\">Order Dataset<\/a><\/li>\n<li><a href=\"https:\/\/data-flair.s3.ap-south-1.amazonaws.com\/Tableau-data\/Sales-details.zip\">Sales Dataset<\/a><\/li>\n<li><a href=\"https:\/\/data-flair.s3.ap-south-1.amazonaws.com\/Tableau-data\/Customer-details.zip\">Customer Dataset<\/a><\/li>\n<li><a href=\"https:\/\/data-flair.s3.ap-south-1.amazonaws.com\/Tableau-data\/Region-details.zip\">Region Dataset<\/a><\/li>\n<li><a href=\"https:\/\/data-flair.s3.ap-south-1.amazonaws.com\/Tableau-data\/Product-details.zip\">Product Dataset<\/a><\/li>\n<\/ul>\n<h3>Types of Filters in Power BI<\/h3>\n<p>There are four types of filter in Power BI. This means that you can apply filters on four different levels in a Power BI dashboard or report. The types of filters are as follows:<\/p>\n<h4>1. Visual-level Filters<\/h4>\n<p>The filters applied to visual-level are applied directly on individual visualizations. Such filters are applied both on data and calculation conditions used within a visualization.<\/p>\n<h4>2. Page-level Filters<\/h4>\n<p>Page-level filters are for a particular page within a report whereas reports are usually of multiple pages. You can apply certain filter conditions on a selected page within a report. Each page in a report can have a different set of filter conditions applied to it.<\/p>\n<h4>3. Report-level Filters<\/h4>\n<p>The report-level filters are the filters that you use to apply a filter condition on the entire report. The report-level filter will get applied to every visualization and page of a report. Thus, unlike visual-level and page-level filters, report-level filters are generalized filters.<\/p>\n<h4>4. Drillthrough Filters<\/h4>\n<p>Using drillthrough filters, you can create a page that mainly focuses on the specific entities. You can add the extra details about your user, customer, manufacturer on a separate page and focus on a specific customer\/manufacturer\/user from the main report.<\/p>\n<h3>How to Apply a Filter in Power BI Desktop<\/h3>\n<p>While you are working with Power BI Desktop, you can make different kinds of visualizations. Generally, you will make a visualization\/dashboard\/report representing all the values in a field. But you can apply filters on the field values and make the dashboard specific to your area of interest. In this section, we will learn how to apply filters on a visual, page and report in Power BI Desktop. To learn along with us, you can open Power BI Desktop and create a visualization or open an existing report.<\/p>\n<h4>Applying Filter to a Visual<\/h4>\n<p>Create or click on a visual in your Power BI Desktop. For instance, we have created a Treemap chart upon which we will apply filters. The Treemap chart shows total sales occurred in each sub-category of products sold.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-section-in-Power-BI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57974\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-section-in-Power-BI.png\" alt=\"Filters section in Power BI\" width=\"1311\" height=\"855\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-section-in-Power-BI.png 1311w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-section-in-Power-BI-150x98.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-section-in-Power-BI-300x196.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-section-in-Power-BI-768x501.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-section-in-Power-BI-1024x668.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-section-in-Power-BI-520x339.png 520w\" sizes=\"auto, (max-width: 1311px) 100vw, 1311px\" \/><\/a><\/p>\n<p>As you can see in the image above, the Treemap chart has two fields; <strong>Sales<\/strong> and<strong> Sub-category<\/strong>. Also, notice that in the Filters section, there are three sub-sections i.e. <em>visual level filters, page level filters and report-level filters.<\/em><\/p>\n<p><em><strong>Must Learn &#8211; <a href=\"https:\/\/data-flair.training\/blogs\/power-bi-treemap\/\">How to Create Treemap in Power BI<\/a><\/strong><\/em><\/p>\n<p>Now, the visual level filter section will show all the fields that you have selected for the visualization. In our case, it is Sales and Sub-category.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Visual-Level-Filters-in-Power-BI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57983\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Visual-Level-Filters-in-Power-BI.png\" alt=\"Visual Level Filters in Power BI\" width=\"223\" height=\"585\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Visual-Level-Filters-in-Power-BI.png 223w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Visual-Level-Filters-in-Power-BI-57x150.png 57w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Visual-Level-Filters-in-Power-BI-114x300.png 114w\" sizes=\"auto, (max-width: 223px) 100vw, 223px\" \/><\/a><\/p>\n<p>If your field is a measure i.e. containing numeric values, then the filter will show filtering criterion for number. That is,<em> \u201cis less than\u2019, \u201cis greater than\u201d, \u201cis\u201d,<\/em> etc. After selecting your criterion, you can also mention a numeric value below for instance, \u201cis less than\u201d and then enter 100000 as value.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-item-in-visual-level-filters.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57984\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-item-in-visual-level-filters.png\" alt=\"Selecting item in visual level filters\" width=\"237\" height=\"597\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-item-in-visual-level-filters.png 237w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-item-in-visual-level-filters-60x150.png 60w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-item-in-visual-level-filters-119x300.png 119w\" sizes=\"auto, (max-width: 237px) 100vw, 237px\" \/><\/a><\/p>\n<p>If a field is a dimension, i.e. having textual value then filtering will be normal. You are given a list of all the available (distinct) values in a selected field. You can apply the filter by selecting the checkboxes. Click on <strong>Apply<\/strong> filter after making your selections.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Basic-Filtering-Sub-category.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57985\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Basic-Filtering-Sub-category.png\" alt=\"Basic Filtering Sub category\" width=\"213\" height=\"569\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Basic-Filtering-Sub-category.png 213w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Basic-Filtering-Sub-category-56x150.png 56w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Basic-Filtering-Sub-category-112x300.png 112w\" sizes=\"auto, (max-width: 213px) 100vw, 213px\" \/><\/a><\/p>\n<h4>Applying Filter to a Page<\/h4>\n<p>After learning how to apply a filter on individual visualizations, we will apply the filter on a complete page of a report.<\/p>\n<p>To do so, drag and drop a field based on which you wish to sort the information on a report page into \u201cpage level report\u201d column.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-and-Fields-section.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57986\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-and-Fields-section.png\" alt=\"Filters and Fields section\" width=\"1912\" height=\"1022\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-and-Fields-section.png 1912w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-and-Fields-section-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-and-Fields-section-300x160.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-and-Fields-section-768x411.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-and-Fields-section-1024x547.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-and-Fields-section-520x278.png 520w\" sizes=\"auto, (max-width: 1912px) 100vw, 1912px\" \/><\/a><\/p>\n<p>Make selections from the field values. Select the values based on which you wish to filter the information. For instance, in our case, we want to view the sales overview information of only the year 2018. In the Filters section, we select only the dates of 2018. The page will automatically change its visuals and show only 2018 related info.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Page-Level-Filters-in-power-Bi.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57987\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Page-Level-Filters-in-power-Bi.png\" alt=\"Page Level Filters in power BI\" width=\"1906\" height=\"1016\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Page-Level-Filters-in-power-Bi.png 1906w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Page-Level-Filters-in-power-Bi-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Page-Level-Filters-in-power-Bi-300x160.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Page-Level-Filters-in-power-Bi-768x409.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Page-Level-Filters-in-power-Bi-1024x546.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Page-Level-Filters-in-power-Bi-520x277.png 520w\" sizes=\"auto, (max-width: 1906px) 100vw, 1906px\" \/><\/a><\/p>\n<h4>Applying Filter to a Report<\/h4>\n<p>To apply a filter to the entire report i.e. to all the pages of a report uniformly, we use report level filters. Drag and drop a field from the <strong>Fields<\/strong> section into the <strong>Report level filters<\/strong> section.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Report-Level-Filters-section.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57988\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Report-Level-Filters-section.png\" alt=\"Report Level Filters section\" width=\"447\" height=\"859\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Report-Level-Filters-section.png 447w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Report-Level-Filters-section-78x150.png 78w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Report-Level-Filters-section-156x300.png 156w\" sizes=\"auto, (max-width: 447px) 100vw, 447px\" \/><\/a><\/p>\n<p>We\u2019ll select all the dates for 2018 so that the visuals show only the information related to that year on all pages.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-dates-in-basic-filtering.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57989\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-dates-in-basic-filtering.png\" alt=\"Selecting dates in basic filtering\" width=\"231\" height=\"573\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-dates-in-basic-filtering.png 231w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-dates-in-basic-filtering-60x150.png 60w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selecting-dates-in-basic-filtering-121x300.png 121w\" sizes=\"auto, (max-width: 231px) 100vw, 231px\" \/><\/a><\/p>\n<p>Apply this filter and all the pages in a report will show sales information for the year 2018 (as shown in the pictures below).<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Overview-of-sales-and-performance-in-Power-BI-Dashboard.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57990\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Overview-of-sales-and-performance-in-Power-BI-Dashboard.png\" alt=\"Overview of sales and performance in Power BI Dashboard\" width=\"1433\" height=\"789\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Overview-of-sales-and-performance-in-Power-BI-Dashboard.png 1433w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Overview-of-sales-and-performance-in-Power-BI-Dashboard-150x83.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Overview-of-sales-and-performance-in-Power-BI-Dashboard-300x165.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Overview-of-sales-and-performance-in-Power-BI-Dashboard-768x423.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Overview-of-sales-and-performance-in-Power-BI-Dashboard-1024x564.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Overview-of-sales-and-performance-in-Power-BI-Dashboard-520x286.png 520w\" sizes=\"auto, (max-width: 1433px) 100vw, 1433px\" \/><\/a><\/p>\n<h3>New Filter Pane Experience in Power BI Desktop<\/h3>\n<p>In the latest edition of <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/get-started\/\">Power BI<\/a>, there is a new option to add a filter pane in your reports. You can add this new filter pane in an existing report or for all the new reports that you will create on Power BI Desktop. From the new filter pane, you can apply filters on a page or on the entire report, format the filter pane to match it with the report\u2019s theme, etc. Also, you can lock filters, hide applies filters from the customers, and change the filter state.<\/p>\n<h4>Add Filter Pane for all New Reports<\/h4>\n<p>To add the new filter pane for all new reports that you\u2019ll make in the future, follow these steps:<\/p>\n<p>Open Power BI Desktop and go to <strong>File<\/strong> tab&gt; <strong>Options<\/strong> <strong>and<\/strong> <strong>settings<\/strong>&gt; <strong>Options<\/strong>.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Options-and-settings-in-File.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57991\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Options-and-settings-in-File.png\" alt=\"Options and settings in File\" width=\"1908\" height=\"1016\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Options-and-settings-in-File.png 1908w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Options-and-settings-in-File-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Options-and-settings-in-File-300x160.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Options-and-settings-in-File-768x409.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Options-and-settings-in-File-1024x545.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Options-and-settings-in-File-520x277.png 520w\" sizes=\"auto, (max-width: 1908px) 100vw, 1908px\" \/><\/a><\/p>\n<p>From the Options dialog box, select <strong>Preview features<\/strong> option. From the available list of options, check the box for \u201cNew filters experience\u201d. Click on <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Preview-features-section-in-option.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57992\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Preview-features-section-in-option.png\" alt=\"Preview features section in option\" width=\"1466\" height=\"992\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Preview-features-section-in-option.png 1466w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Preview-features-section-in-option-150x102.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Preview-features-section-in-option-300x203.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Preview-features-section-in-option-768x520.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Preview-features-section-in-option-1024x693.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Preview-features-section-in-option-520x352.png 520w\" sizes=\"auto, (max-width: 1466px) 100vw, 1466px\" \/><\/a><\/p>\n<h4>Add Filter Pane for an Existing Report<\/h4>\n<p>To add the filter pane for an existing report, open the report and go to <strong>File<\/strong> tab&gt; <strong>Options and settings<\/strong>&gt; <strong>Options<\/strong>. Then, select <strong>Report settings<\/strong>. In the Filtering experience section, select \u201cEnable the updated filter pane, and show filters in the visual header for this report\u201d. Click on <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filtering-experience-section-in-power-BI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57993\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filtering-experience-section-in-power-BI.png\" alt=\"Filtering experience section in power BI\" width=\"803\" height=\"819\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filtering-experience-section-in-power-BI.png 803w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filtering-experience-section-in-power-BI-147x150.png 147w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filtering-experience-section-in-power-BI-294x300.png 294w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filtering-experience-section-in-power-BI-768x783.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filtering-experience-section-in-power-BI-520x530.png 520w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/a><\/p>\n<p>The new filter pane will get added on the right of your report editor.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-pin-at-the-side.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57994\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-pin-at-the-side.png\" alt=\"Filters pin at the side\" width=\"1916\" height=\"1028\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-pin-at-the-side.png 1916w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-pin-at-the-side-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-pin-at-the-side-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-pin-at-the-side-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-pin-at-the-side-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-pin-at-the-side-520x279.png 520w\" sizes=\"auto, (max-width: 1916px) 100vw, 1916px\" \/><\/a><\/p>\n<p>To apply filtering conditions on the visual\/page\/report, drag and drop the field on the respective column in the filter pane. For instance, we selected the field <strong>Order Date<\/strong>. After putting it on the filter pane, we selected all the dates of the year 2019. This filtered the information of all visuals to just 2019 related statistics. Each visualization will have a filter icon on the side of it whenever you hover over it. Click on that icon and you will see the details of currently applied filter on that visual.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Order-Date-in-Power-BI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57995\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Order-Date-in-Power-BI.png\" alt=\"Order Date in Power BI\" width=\"1906\" height=\"841\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Order-Date-in-Power-BI.png 1906w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Order-Date-in-Power-BI-150x66.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Order-Date-in-Power-BI-300x132.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Order-Date-in-Power-BI-768x339.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Order-Date-in-Power-BI-1024x452.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Order-Date-in-Power-BI-520x229.png 520w\" sizes=\"auto, (max-width: 1906px) 100vw, 1906px\" \/><\/a><\/p>\n<h4>Format the Filter Pane<\/h4>\n<p>You can format this filter pane using the formatting options for filter pane and filter cards given on the right of report editor.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-and-Filter-Cards-in-Power-BI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57996\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-and-Filter-Cards-in-Power-BI.png\" alt=\"Filter Pane and Filter Cards in Power BI\" width=\"675\" height=\"805\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-and-Filter-Cards-in-Power-BI.png 675w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-and-Filter-Cards-in-Power-BI-126x150.png 126w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-and-Filter-Cards-in-Power-BI-252x300.png 252w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-and-Filter-Cards-in-Power-BI-520x620.png 520w\" sizes=\"auto, (max-width: 675px) 100vw, 675px\" \/><\/a><\/p>\n<p>In the <strong>Filter pane<\/strong> option, you will get formatting options for background color, transparency, font+ icon color, title text size, header text size, font, etc. You can make changes here as you like.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-Editing-options.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57997\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-Editing-options.png\" alt=\"Filter Pane Editing options\" width=\"223\" height=\"595\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-Editing-options.png 223w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-Editing-options-56x150.png 56w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-Pane-Editing-options-112x300.png 112w\" sizes=\"auto, (max-width: 223px) 100vw, 223px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-cards-editing-options.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57998\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-cards-editing-options.png\" alt=\"Filter cards editing options\" width=\"213\" height=\"591\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-cards-editing-options.png 213w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-cards-editing-options-54x150.png 54w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filter-cards-editing-options-108x300.png 108w\" sizes=\"auto, (max-width: 213px) 100vw, 213px\" \/><\/a><\/p>\n<p>As you can see in the picture below, we have formatted our filter pane and changed its background color, font size, etc.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-added-on-Dashboard.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-57999\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-added-on-Dashboard.png\" alt=\"Filters added on Dashboard\" width=\"1918\" height=\"837\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-added-on-Dashboard.png 1918w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-added-on-Dashboard-150x65.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-added-on-Dashboard-300x131.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-added-on-Dashboard-768x335.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-added-on-Dashboard-1024x447.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Filters-added-on-Dashboard-520x227.png 520w\" sizes=\"auto, (max-width: 1918px) 100vw, 1918px\" \/><\/a><\/p>\n<h3>Apply Filters in Power BI Workspace<\/h3>\n<p>We have seen in our <a href=\"https:\/\/data-flair.training\/blogs\/power-bi-dashboard\/\"><strong>Power BI dashboard tutorial<\/strong> <\/a>that we can publish Power BI reports on the web. You can use the filter there as well.<\/p>\n<p>Open your Power BI workspace on the web. And, select a report that is already been uploaded on it. Once the report opens, you will see a <strong>Filters<\/strong> pane on the right, in which you will see the currently applied filters on the report or on an individual visualization.<\/p>\n<h4>Adding Filter in Edit Report Mode<\/h4>\n<p>To apply new filters on the report, go to <strong>Edit report<\/strong> option.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Edit-report-option-in-Power-BI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-58000\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Edit-report-option-in-Power-BI.png\" alt=\"Edit report option in Power BI\" width=\"1914\" height=\"987\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Edit-report-option-in-Power-BI.png 1914w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Edit-report-option-in-Power-BI-150x77.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Edit-report-option-in-Power-BI-300x155.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Edit-report-option-in-Power-BI-768x396.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Edit-report-option-in-Power-BI-1024x528.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Edit-report-option-in-Power-BI-520x268.png 520w\" sizes=\"auto, (max-width: 1914px) 100vw, 1914px\" \/><\/a><\/p>\n<p>Drag and drop the fields of your choice on the <strong>Page level filters<\/strong> or <strong>Report level filters<\/strong> column.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Types-of-filters-in-Power-BI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-58001\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Types-of-filters-in-Power-BI.png\" alt=\"Types of filters in Power BI\" width=\"1916\" height=\"995\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Types-of-filters-in-Power-BI.png 1916w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Types-of-filters-in-Power-BI-150x78.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Types-of-filters-in-Power-BI-300x156.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Types-of-filters-in-Power-BI-768x399.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Types-of-filters-in-Power-BI-1024x532.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Types-of-filters-in-Power-BI-520x270.png 520w\" sizes=\"auto, (max-width: 1916px) 100vw, 1916px\" \/><\/a><\/p>\n<p>Select the values based on which you want to sort the information of the report. The visualizations of the report will automatically transform themselves as per the filters applied.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selected-dates-in-Power-BI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-58003\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selected-dates-in-Power-BI.png\" alt=\"Selected dates in Power BI\" width=\"1916\" height=\"985\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selected-dates-in-Power-BI.png 1916w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selected-dates-in-Power-BI-150x77.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selected-dates-in-Power-BI-300x154.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selected-dates-in-Power-BI-768x395.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selected-dates-in-Power-BI-1024x526.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Selected-dates-in-Power-BI-520x267.png 520w\" sizes=\"auto, (max-width: 1916px) 100vw, 1916px\" \/><\/a><\/p>\n<h4>Filters in Reading view mode<\/h4>\n<p>In the reading view mode, one cannot edit i.e. add or remove the filters that are applied to the report. Rather, they can only view what are the current filters that are applied to the report by the report designer.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Final-Layout-of-Applied-Filters.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-58004\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Final-Layout-of-Applied-Filters.png\" alt=\"Final Layout of Applied Filters\" width=\"1914\" height=\"1032\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Final-Layout-of-Applied-Filters.png 1914w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Final-Layout-of-Applied-Filters-150x81.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Final-Layout-of-Applied-Filters-300x162.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Final-Layout-of-Applied-Filters-768x414.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Final-Layout-of-Applied-Filters-1024x552.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Final-Layout-of-Applied-Filters-520x280.png 520w\" sizes=\"auto, (max-width: 1914px) 100vw, 1914px\" \/><\/a><\/p>\n<h2>Summary<\/h2>\n<p>With this, we conclude our tutorial of Power BI filters. We hope our explanation was informative and helpful. With this information, you can easily work with filters in Power BI Desktop and apply filtering conditions on the data of a report. Power BI is an interactive tool and it instantly reacts to the filters applied on a report and changes it accordingly.<\/p>\n<p>In case of any query or suggestion, leave your comments in the comment section below.<\/p>\n<p><em><strong>Get your first job in Power BI field by practicing <a href=\"https:\/\/data-flair.training\/blogs\/power-bi-interview-questions\/\">Power BI Interview Questions<\/a><\/strong><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>After gaining basic knowledge of Power BI, let&#8217;s move on to the role of filters in Power BI reports and dashboards. Along with the theoretical knowledge, we\u2019ll also learn how to apply and use&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":58046,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[20040,9711,15090],"class_list":["post-20685","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-apply-filters-in-power-bi-desktop","tag-power-bi-filter","tag-types-of-power-bi-filter"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Understand Power BI Filters to take your business to next level! - DataFlair<\/title>\n<meta name=\"description\" content=\"With Power BI Filters tutorial, learn types of filters, adding filter in Power BI desktop, new filter pane experience &amp; adding filter in Power BI workspace.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/power-bi-filter\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Understand Power BI Filters to take your business to next level! - DataFlair\" \/>\n<meta property=\"og:description\" content=\"With Power BI Filters tutorial, learn types of filters, adding filter in Power BI desktop, new filter pane experience &amp; adding filter in Power BI workspace.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/power-bi-filter\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-30T03:30:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-25T15:40:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Power-BI-filters1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Understand Power BI Filters to take your business to next level! - DataFlair","description":"With Power BI Filters tutorial, learn types of filters, adding filter in Power BI desktop, new filter pane experience & adding filter in Power BI workspace.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/","og_locale":"en_US","og_type":"article","og_title":"Understand Power BI Filters to take your business to next level! - DataFlair","og_description":"With Power BI Filters tutorial, learn types of filters, adding filter in Power BI desktop, new filter pane experience & adding filter in Power BI workspace.","og_url":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-07-30T03:30:14+00:00","article_modified_time":"2020-06-25T15:40:33+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Power-BI-filters1.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Understand Power BI Filters to take your business to next level!","datePublished":"2018-07-30T03:30:14+00:00","dateModified":"2020-06-25T15:40:33+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/"},"wordCount":1629,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Power-BI-filters1.jpg","keywords":["Apply Filters in Power BI Desktop","power BI Filter","Types of Power BI Filter"],"articleSection":["Power BI Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/power-bi-filter\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/","url":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/","name":"Understand Power BI Filters to take your business to next level! - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Power-BI-filters1.jpg","datePublished":"2018-07-30T03:30:14+00:00","dateModified":"2020-06-25T15:40:33+00:00","description":"With Power BI Filters tutorial, learn types of filters, adding filter in Power BI desktop, new filter pane experience & adding filter in Power BI workspace.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/power-bi-filter\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Power-BI-filters1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Power-BI-filters1.jpg","width":802,"height":420,"caption":"Power BI filters topics"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/power-bi-filter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Power BI Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/power-bi\/"},{"@type":"ListItem","position":3,"name":"Understand Power BI Filters to take your business to next level!"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/20685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=20685"}],"version-history":[{"count":7,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/20685\/revisions"}],"predecessor-version":[{"id":78725,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/20685\/revisions\/78725"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/58046"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=20685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=20685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=20685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}