LOADING

Type to search

Line Chart , Area Chart, Slicer , Formatting in Power BI

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Line Chart , Area Chart, Slicer , Formatting in Power BI

Share

If you are looking for a Microsoft Power BI Corporate Training in Gurgaon , please feel free to reach out at akriti.lal@instrovate.com or whatsapp at +91-9953805788 

 

In today’s blog I will explain an example of timeseries using Line chart, Area charts and Slicer visualization.

We will also explore different ‘Format’ options for line chart.

 

Load data for timeseries exercise:Line Chart , Area Chart, Slicer , Formatting in Power BI 29

We have table fields in Power BI

Line Chart , Area Chart, Slicer , Formatting in Power BI 30

Now let’s select Period and Attendance:

Line Chart , Area Chart, Slicer , Formatting in Power BI 31

Select a line chart:

Line Chart , Area Chart, Slicer , Formatting in Power BI 32

As we know we can drill into any chart, by 3 ways

Lets we explore how results will come in this example. Select Show next level option:

Line Chart , Area Chart, Slicer , Formatting in Power BI 33

We can see results in Qtr . we have aggregated data for all years into four Quarters irrespective of the years.

Click on next level again:

Line Chart , Area Chart, Slicer , Formatting in Power BI 34

Here we have results as per Months irrespective of the years.

Now click on Drill and go to the level from where we start drill down:

Line Chart , Area Chart, Slicer , Formatting in Power BI 35

Now let see for other option for drill down, Expand next level:

Line Chart , Area Chart, Slicer , Formatting in Power BI 36

Click one more time on Expand next level:

Line Chart , Area Chart, Slicer , Formatting in Power BI 37

Click again on the Expand next level:

Line Chart , Area Chart, Slicer , Formatting in Power BI 38

Here we have data in day’s form

Let me explain one more thing here, we can format X axis and Y axis too.

Go to format:

Line Chart , Area Chart, Slicer , Formatting in Power BI 39we can see format option for our chart. Select X axis, it will open different list for x axis:

Line Chart , Area Chart, Slicer , Formatting in Power BI 40

Lets change type for x axis, change type to Categorical:

Line Chart , Area Chart, Slicer , Formatting in Power BI 41

It will change data in category in place of continuous.

Select drill up:

Line Chart , Area Chart, Slicer , Formatting in Power BI 42

Now we can see results in different Quarters in categorical type.

Click on drill up till it reach to the last step where we started drill down

Line Chart , Area Chart, Slicer , Formatting in Power BI 43

In format pan we can see more options for x axis

We can change title colour for axis:

Line Chart , Area Chart, Slicer , Formatting in Power BI 44

Click on Y axis:

Line Chart , Area Chart, Slicer , Formatting in Power BI 45

Change position and title for y axis:

Line Chart , Area Chart, Slicer , Formatting in Power BI 46

Now let check options for Shapes:

Line Chart , Area Chart, Slicer , Formatting in Power BI 47

Change few things for line chart:

Line Chart , Area Chart, Slicer , Formatting in Power BI 48

Change colour for data:

Line Chart , Area Chart, Slicer , Formatting in Power BI 49

 

Now we will cover granularity and aggregation of data:

In our previous map we have aggregated results for Gender, now we will select Gender to check both results separately.

Line Chart , Area Chart, Slicer , Formatting in Power BI 50

Now we have separate results for Boys and girls

Line Chart , Area Chart, Slicer , Formatting in Power BI 51

 

Here we have increase the level of granularity and decrease the level of aggregation.

 

Now if we have to aggregate for age group in place of Gender. So drag Age to Legend :

Line Chart , Area Chart, Slicer , Formatting in Power BI 52

Now results are on the basis of age group.

Line Chart , Area Chart, Slicer , Formatting in Power BI 53

 

Line Chart , Area Chart, Slicer , Formatting in Power BI 54

Select Average of Attendance value:

Line Chart , Area Chart, Slicer , Formatting in Power BI 55

 

Now we will change Line chart into area chart, select Area chart from visualization.

Line Chart , Area Chart, Slicer , Formatting in Power BI 56

 

Select Stacked are chart:

Line Chart , Area Chart, Slicer , Formatting in Power BI 57

Difference between Area chart and Stacked Area chart is that in Area chart some area is covered from other result, but in stacked area chart they are stacked on each other and rage changes respectively on Y axis

Now

Line Chart , Area Chart, Slicer , Formatting in Power BI 58

We can use filter for Age criteria:

Line Chart , Area Chart, Slicer , Formatting in Power BI 59

This chart is showing results only for ages, (19 to 21 years) and  (22 years and over )

 

Now we will learn to add more than one visualization on one page:

Click outside the chart

Line Chart , Area Chart, Slicer , Formatting in Power BI 60

No field is selected from FIELDS

Slicer is like a filter but it is on the same page on the visualization and very easy to use.

Select slicer from visualization:

Line Chart , Area Chart, Slicer , Formatting in Power BI 61

 

Select Period

Line Chart , Area Chart, Slicer , Formatting in Power BI 62

Create one more slicer with Gender field:

Line Chart , Area Chart, Slicer , Formatting in Power BI 63

We can change size and place of slicer on page, we can scroll around for Period slicer and it will automatically change result for chart as we did in Filter.

Line Chart , Area Chart, Slicer , Formatting in Power BI 64

Apply Filter scrolling on dates for Period Slicer and select any option from Gender slicer, it changes Result for chart respectively:

 

Line Chart , Area Chart, Slicer , Formatting in Power BI 65

Add one more slicer for Age group

Line Chart , Area Chart, Slicer , Formatting in Power BI 66

We can select more than one option using Ctrl button for age group:

Line Chart , Area Chart, Slicer , Formatting in Power BI 67

 

It was all about using area chart and more than one chart in same page and use of Slicer.

Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *