How To Add Drop Down List In Power Bi

How to add a drop-down list in Power BI

Adding a drop-down list in Power BI can be done using the slicer feature. Slicers allow you to filter your data visually and easily select specific values from a list.

Here is a step-by-step guide on how to add a drop-down list using slicers in Power BI:

1. Open your Power BI report and navigate to the page where you want to add the drop-down list.
2. In the “Visualizations” pane on the right side of the screen, click on the “Slicer” option. This will add a new blank slicer visual to your report canvas.
3. Click on the field from your dataset that you want to use as the drop-down list. This will populate the slicer with values from that field.
4. Customize the appearance and behavior of the slicer by using the options in the “Visualizations” pane. You can change the style, orientation, and layout of the drop-down list to fit your report’s design.
5. Resize and position the slicer visual on the report canvas as desired.
6. Test the drop-down list by selecting different values. You will notice that the data in other visuals on the same page will be filtered based on your selection.

Here is an example to illustrate the process:

In this example, we have a drop-down list slicer added to a report page. The slicer is connected to a “Category” field from the dataset, allowing the user to easily filter the data by category.