Exploring slicers and filters
Slicers allow Power BI users to apply filters dynamically to data shown in visuals. This is helpful when you have an entire dataset that can be divided or segmented to show different characteristics of the data. For example, our sales database contains both store sales and customer addresses and the associated relationship between the two. This means we can use the map and table visuals to see how many sales we have in each state of the United States, as shown in Figure 12.1:
As we increase our understanding of this data, we will want to be able to better understand how the net store sales compare for each state. Some states seem to be very close in net store sales. To help us, we're going to use the slicer visual and add the ca_state
column to the slicer visual. This means we can select just the states Iowa and Missouri. The table and map visuals will filter to only those...