How To Add Dropdown In Power Bi

by

How to Add Dropdown in Power BI

To add a dropdown in Power BI, you can use the “Dropdown” data type available in the “Data” tab. Here is a step-by-step guide on how to do it:

  1. Open Power BI and go to the “Data” tab.
  2. In the “Fields” pane on the right, right-click on the field you want to use for the dropdown and click on “Change Type”.
  3. Select “Dropdown” from the available data types.
  4. A new column will be created in the “Fields” pane with the selected field as a dropdown.
  5. Drag and drop the new dropdown field onto your report canvas.

That’s it! You have now added a dropdown in Power BI. You can further customize the dropdown by changing its properties, such as adding default values, enabling multi-select, etc.

Here’s an example of how the dropdown might look like in an HTML page:

  <html>
    <head>
      <style>
        .dropdown {
          width: 200px;
          height: 30px;
          background-color: #fff;
          border: 1px solid #ccc;
          border-radius: 5px;
          padding: 5px;
        }
      </style>
    </head>
    <body>
      <div class="dropdown">
        <select id="dropdownField">
          <option value="option1">Option 1</option>
          <option value="option2">Option 2</option>
          <option value="option3">Option 3</option>
        </select>
      </div>
    </body>
  </html>

Read more interesting post

Leave a comment