There are multitude of ways and means to filter in Power BI. A few snacks back, we talked about how the visualizations can filter one another. Additionally, specific visuals can be included for nothing more than filtering. If you scan through the visualizaiton icons, you will find such filter called "Slicer."
- Click out in the blank space so that you are sure to have nothing selected.
- Find and click the SLICER visualization under the Visualizations tab.
- Drag and drop SEGMENT from the Data Panel into the Visualization Panel Field
- You should see the visualization populate with the market segments.
- Click the boxes and watch the changes
- Unclick all boxes
- Format your visual
- Under Slicer Settings, you will see that this visual has three.
- Vertical List
- Tile
- Drop Down
- Cycle through them and see what happens
- Choose Drop Down when done playing around
- As with other visuals there are other modifications you can make it look just how you like.
- Move and Size your visual to make the most of the space on the page.
- SAVE!!
- Click in the blank space of your report again to ensure nothing is selected.
- Drag and drop the following fields from the data panel to the little box under "Filter on all pages"
- Date
- Discount Band
- Product
- Segment
- SAVE!!
- Require single selection
- This will force the user to choose only one item, though they can still CTRL+Click to choose more.
- Filter type
- Basic filtering
- Offers a list of choices
- Advanced filtering
- Offers a sort of query view enabling more exacting choices
- Relative Date & Relative Time
- Only available for Date fields
- Enables a user to choose a period
- In the last ... however many whatever
- In this ... whatever
- In the next ... however many whatever
- requires futures dates
- Expand or collapse filter card
- Remove (the filter card)
- Lock (the filter so it cannot be changed)
- Hide (nobody can see this filter card when it is published)