Power BI Marketplace Power BI has a range of wonderful visuals to choose from but as well as that we can explore what's called the Power BI Marketplace. It's an online area that we can use to find other chart types that we may be don't usually have in our Power BI report.

We can quickly search for those chart types added into the report and then it's available anytime we want. So for example, histograms, word charts, bullet charts, or play-axis are just some of the common ones that we don't normally have by default in a Power BI report.

We're gonna have a look at one of these chart types and it's a play Axis play axes is a wonderful way to animate a chart especially a line chart and it brings it to life. So instead of exploring the data each year ourselves, we can animate it and let Power BI run through each year, or month, or quarter, or day automatically, so it's ideal for working with a time series and it brings our charts to life by animating them and making them much more Interactive.

And it applies to all the visuals on the page.

Let's do a workout and see how to use the Power BI Marketplace in Power BI.

So I'm going to use my Excel data here, module 4 lesson 6 workout.

And we'll select a worksheet from here.

So I'm going to take L6 Commodities. L6 Commodities has the price of lots of different Commodities. We'll use gold and it has that price for a range of different dates from 1992 up to the current day.

So I'm going to load that into my report.

And I'm going to create a line chart with that data.

I'll take it here my date field, remember date fields are hierarchical, we'll come back to that in a second. But if I choose a date field here and bring in the price of gold.

And make it a line chart, we have a fluctuation here of the price of gold over by the 20 or 30 year period.

Now I'm going to take off the year from my hierarchy so I can see down here in the x-axis that it's grouped the data by year. So I'm going to x that out and I'm also going to take off the quarter. So now I'm just looking at it per month. But of course that's the total revenue, or the total price I should say for all Januarys all Februarys and so on. What I want to do is look at a particular year. Now, I could add a slicer in and filter it that way, but instead I'm going to animate it. I'm going to bring it to life by adding in a play axis. So I'm going to explore the Power BI Marketplace to find it. I'm going to click on the three dots here the ellipsis at the bottom right of the visualization section, and that will allow me to get more visuals.

Now there are quite a lot of different charts in here. If you know the one that you're looking for, it's much easier just to search for it. I'm just typing it in here and I find a play axis visual. So I'm just going to click on that.

And then I can add it in to my Power BI report. Now, if you've added any extra visuals in they will always sit at the bottom down here and they will be there for any page in that particular report.

So I'm just going to click on to the canvas and add this chart in and I'm going to give it a field like I would any visual so I'm going to click on my date here and I'm just going to open it up because I want to select just the year part. So if I click on that.

There we go and now all I have to do is press play, so if I click on play and any chart on the page, so my line chart here my comes to life as it works its way through the time series showing me the results for that data for each year in the data set.