Power BI: IPL Analytics- Visualizations and Design Reports -Part 3

In my previous blog, we configured Treemap visualization, here let us add few more visualizations in the same report.

If we want to filter the report data based on the venue of the matches and see the entire analysis of the IPL location wise, Power BI provides a very useful feature called Slicer. Slicer would be very good to be used in below scenarios

Display commonly-used or important filters on the report canvas for easier access.
Make it easier to see the current filtered state without having to open a drop-down list.

Kindly refer Microsoft docs for more information about the usage of Slicer visualization

Slicers in Power BI

Let us go ahead and add a slicer visual on the report at top left corner as shown in below snippets

Select the slicer visual and drag and drop on the page canvas.

Select the Venue_Name field from the Match table and drag it to the report field.

We can format the slicer as required. One example is as shown below, let us add a Title as “Select Venue”, change the font color etc.

Once we finish the formatting, it will reflect as shown in below snippet. Its a list of all unique venues where matches were played and we can either select all/ multiple or single venue for the filtering purpose.

Now you would wonder how does this Slicer can control /filter data for entire report and rest of visuals. Here is the magic. Just select the Slicer visual and go to Format menu on the ribbon. If the Edit Interactions button is selected, it means Slicer control interacts with rest of visuals. Once the Slicer and Edit Interactions both are selected, we can see a filter icon and a none icon on rest of the visuals as shown in below snippet.

These are important icons for the interactions.

Filter: Once the filter is selected, it is shown in black and reflects that the filter will be applied based on the Slicer control. If we do not want to filter, just click on it so that it turns white.