{"id":1340,"date":"2023-09-29T12:02:39","date_gmt":"2023-09-29T10:02:39","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1340"},"modified":"2023-09-29T12:02:39","modified_gmt":"2023-09-29T10:02:39","slug":"hide-columns-inside-power-bi-like-in-excel","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1340","title":{"rendered":"Hide columns inside Power BI like in Excel"},"content":{"rendered":"\n<p>Inside excel you have the possibility to hide columns inside tables and pivot tables.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"509\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image.png\" alt=\"\" class=\"wp-image-1341\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-300x162.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-768x414.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Inside Power BI you don\u2018t have the possibility.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-1.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"508\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-1.png\" alt=\"\" class=\"wp-image-1342\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-1.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-1-300x161.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-1-768x413.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>If you want to achieve this behavior, there are some options. In this example I have created a pivot table inside Power BI<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-2.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"438\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-2.png\" alt=\"\" class=\"wp-image-1343\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-2.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-2-300x139.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-2-768x356.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Next, you can create a field parameter. There you can place the fields which are used on the matrix<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-3.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"906\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-3.png\" alt=\"\" class=\"wp-image-1344\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-3.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-3-300x288.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-3-768x736.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Now, you must remove the fields from the matrix at replace it from the new parameter:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-4.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"308\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-4.png\" alt=\"\" class=\"wp-image-1345\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-4.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-4-300x98.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-4-768x250.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>if you\u2018re using the table visual, it is very easy to add to or remove the columns with a slicer. But, if you are using a matrix, you need to drill down if you add new columns. The order will be lost after adding or removing columns. You need to tick the fields by the original order.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-5.png\"><img decoding=\"async\" loading=\"lazy\" width=\"784\" height=\"510\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-5.png\" alt=\"\" class=\"wp-image-1346\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-5.png 784w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-5-300x195.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2023\/09\/image-5-768x500.png 768w\" sizes=\"(max-width: 784px) 100vw, 784px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Inside excel you have the possibility to hide columns inside tables and pivot tables. Inside Power BI you don\u2018t have the possibility. If you want to achieve this behavior, there are some options. In this example I have created a &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=1340\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1340"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1340"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1340\/revisions"}],"predecessor-version":[{"id":1347,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1340\/revisions\/1347"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}