{"id":3888,"date":"2021-12-30T09:13:39","date_gmt":"2021-12-30T17:13:39","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3888"},"modified":"2021-12-30T09:13:42","modified_gmt":"2021-12-30T17:13:42","slug":"how-to-add-a-button-using-bookmarks-in-power-bi","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3888","title":{"rendered":"How To Add A Button Using Bookmarks In Power BI"},"content":{"rendered":"\n

In this article, you will learn how to create a button and how to use it in Power BI reports. In a Power BI report, you can add different types of buttons, as shown in the below image. <\/p>\n\n\n\n

\"How<\/figure>\n\n\n\n

 In this article, I will create a button using a bookmark. A bookmark is a very useful feature of Power BI. Using a bookmark, you can capture the current view of a report including filters and visuals used in the report. Whatever you configured in a bookmark you can get it by selecting the saved bookmark. You can also create a collection of bookmarks and arranged them in any order. To create a button with a bookmark, you need to create a bookmark first. To create a bookmark, go to the \u2018View\u2019 tab of the Power BI desktop and click on Bookmarks. <\/p>\n\n\n\n

\"How<\/figure>\n\n\n\n

  When you create a bookmark, the below elements are saved with the bookmark:<\/p>\n\n\n\n

  1. The current state of the report\/page<\/li>
  2. Applied Filters<\/li>
  3. Slicers, including slicer type (for example, dropdown or list) and slicer state<\/li>
  4. Visual selection state (such as cross-highlight filters)<\/li>
  5. Sort order<\/li>
  6. Drill location<\/li>
  7. Visibility of an object (by using the Selection pane)<\/li>
  8. The focus or Spotlight modes of any visible object<\/li><\/ol>\n\n\n\n

    I am going to create a report using the \u2018Employee\u2019 table and \u2018Department\u2019 table. I have already imported the data from these two tables. I want to create a report where I can check the data in the table by clicking on a button. I will create 3 or 4 buttons according to the department name. Once I click on the \u2018MKT\u2019 button, I will get data of employees of the MKT department. Similarly, if I click on another button that represents the second department, I will get the data accordingly. See the below steps to perform this task. Step 1<\/strong> Import your data from the source. I have loaded two tables. See the below image <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

      See the data of employee table and Department table. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n
    \"How<\/figure>\n\n\n\n

     See the relationship between these two tables. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

    Step 2<\/strong> Select table visual and data from these two tables. As we see a relationship between these two tables, we can select the column from both tables in a single visual. See the below image. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

      Now, I will add a filter on the department name and create a bookmark for each department. For example, first I will apply a filter for the \u2018MKT\u2019 department. See the below image. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

      Now create a bookmark on it. Go to the \u2018view\u2019 tab and click on \u2018Bookmark\u2019. When you click on \u2018add\u2019, a bookmark will be created with the default name \u2018Bookmark 1\u2019. You can rename it by double clicking on it. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

      Similarly, by changing the filter you can add other bookmarks according to the department name. I have added five such bookmarks. To view these bookmarks you can click on \u2018View\u2019. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

    Step 3<\/strong> Now I am creating the buttons using these bookmarks. To add a button, go to the \u2018Insert\u2019 tab and click on the drop-down \u2018Button\u2019 option. Select \u2018Bookmark\u2019. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

      A button will be added to your report. Rearrange the position according to your requirement by simply dragging and dropping. Give the name of the button by \u2018button text\u2019. Also, you can change the font color, background color, and alignment, etc. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

      Go to the \u2018Action\u2019 and Bookmark as \u2018MKT\u2019. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

      Your button will be created and once you click on it with \u2018Ctrl\u2019 (Ctrl+Click on the button) it will work and will show the data of the \u2018MKT\u201d department. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

      Similarly, you can add more buttons to your report. I have added all five buttons according to my different department names. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

      If you want to remove the bookmark sign from the button, you can set the \u2018Shape\u2019 as blank from the \u2018Icon\u2019 activity. <\/p>\n\n\n\n

    \"How<\/figure>\n\n\n\n

    Summary<\/h2>\n\n\n\n

     I hope you understood how to create a button using a bookmark. This is a very useful task to add a button in reports. Thanks for reading.<\/p>\n\n\n\n

    Ref: https:\/\/www.c-sharpcorner.com\/article\/how-to-add-button-using-bookmarks-in-power-bi\/<\/p>\n","protected":false},"excerpt":{"rendered":"

    In this article, you will learn how to create a button and how to use it in Power BI reports. In a Power BI report, you can add different types of buttons, as shown in the below image.   In this article, I will create a button using a bookmark. A bookmark is a very useful Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[1021,1020],"class_list":["post-3888","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-add-a-button-power-bi","tag-add-a-button-using-bookmarks-in-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3888","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3888"}],"version-history":[{"count":2,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3888\/revisions"}],"predecessor-version":[{"id":3890,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3888\/revisions\/3890"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}