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

In my previous blog, we configured Slicer visualization, Let us add few more visualizations in the same report.

If we want to show the match locations on a World map along with the density of number of matches played in a visual way, we can use the Map Visual as shown in below snippet. As usual, let us drag and drop it on the report canvas.

New Report-Second chart1

Once its dropped at the center, we can resize it as required and place it at the required place in report canvas. If you see in the below snippet, we can see the location as one property of the visual where we mapped the City-Name. On the similar lines we can use any other location field. If you remember in my earlier data modelling post, we have changed the type of this field to City so that we can use this field in Map visuals.

There are multiple other properties of the Map visual which can be used as mentioned below-

Size: this would determine the size of the bubble at that location. Here we have Count of match_id which decided the size of the bubble.

Color Saturation: this would determine the darkness of the color based on the field associated with it. Here we have Count of match_id which decides the color saturation of the bubble.

My recommendation would be to try out various settings of the visual so that you are comfortable using the same.
New Report-Second chart2

We can see the various sizes and color shades at match locations in below map visual
New Report-Second chart3

If without dropping the Map visual, we directly select any location type field and drag and drop on the report canvas, it will automatically add the Map visual and set its location property to selected Location type field.

We have completed configuring basic Map visual in Power BI.

Let us continue to develop this report by adding more visualizations in my next blog. I am sure you would love to do this with me.

Thank you for reading my blog, if you have any questions please mention in the comments and hit the like button if you like my write up.

Keep Learning !! Happy analyzing and be Powerful πŸ™‚

Continue reading “Power BI: IPL Analytics- Visualizations and Design Reports -Part 4”

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.

Slicer chart1

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

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.Slicer chart3

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.Slicer chart4

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.Slicer chart6

These are important icons for the interactions.

Slicer chart7Filter: 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.

Slicer chart7.5None: We can select the None icon in case we want to exclude this chart from filtering and slicer filter will not be applied to the chart.

 

We can even use the Slicer on this page to control other report pages.

I would request you to play around this particular setting and understand more about the Slicer interactions.

We have completed configuring Slicer in Power BI report.

Let us continue to develop this report by adding more visualizations in my next blog. I am sure you would love to do this with me.

Thank you for reading my blog, if you have any questions please mention in the comments and hit the like button if you like my write up.

Keep Learning !! Happy analyzing and be Powerful πŸ™‚

Continue reading “Power BI: IPL Analytics- Visualizations and Design Reports -Part 3”