LOADING

Type to search

Colors , Filters , Quick Charts in Microsoft 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

Colors , Filters , Quick Charts in Microsoft Power BI

Share

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

 

Now we are going to experience data with different colours. It will be easy and interesting to add colours to our different fields. We will be working with the below sample data

Orderdate

Item

Region

Cost

Unit

Total

1/1/2015

Copy

East

1.99

20

39.8

4/2/2015

Pen

West

2

10

20

5/1/2016

Pencil

East

10

10

100

25/1/2016

Pencil

East

10

10

100

2/2/2017

Pen

South

15

10

150

1/2/2015

Copy

East

1.99

20

39.8

5/2/2015

Pen

West

2

10

20

5/1/2016

Pencil

East

10

10

100

1/3/2016

Eraser

Central

15

10

150

10/10/2017

Pen

West

11

10

110

1/1/2017

Bag

Central

10

10

100

 

 

 

Load a sample file in Power BI:

Colors , Filters , Quick Charts in Microsoft Power BI 29

Select Unit & Region and click on bar chart:

Colors , Filters , Quick Charts in Microsoft Power BI 30

Check for Axis field, Region is present there it is for horizontal axis.

Select ‘Item’ field and drag to the Axis with ‘Region’:

Colors , Filters , Quick Charts in Microsoft Power BI 31Now we have two fields on same axis.

click on Expand next level:

Colors , Filters , Quick Charts in Microsoft Power BI 32

It will display result with Region and Item. Results are in sorting order. We can change this order:

Colors , Filters , Quick Charts in Microsoft Power BI 33

 

Colors , Filters , Quick Charts in Microsoft Power BI 34

Now we want to add some colour so that we can see data not only by text but also from colours.

Select Unit field and drag it to the Color saturation:

Colors , Filters , Quick Charts in Microsoft Power BI 35

We can see more prominent colour for high units and light colour for less units.

Remove unit from color saturation and drag and drop Region fields under Legend:

Colors , Filters , Quick Charts in Microsoft Power BI 36

So now we can identify Region field by different colours.

We can change these colours. Go to Format (next to Fields)

Colors , Filters , Quick Charts in Microsoft Power BI 37

Click on format

Colors , Filters , Quick Charts in Microsoft Power BI 38

Select any colour to change existing colours:

Colors , Filters , Quick Charts in Microsoft Power BI 39

It was about adding records on axis and giving colours to data.

Let we explore more option with adding colour in different type of Visualizations:

Let we select waterfall model

Colors , Filters , Quick Charts in Microsoft Power BI 40

Go to format:

Colors , Filters , Quick Charts in Microsoft Power BI 41

From Sentiment colors we can change colors for increase, decrease and total data

Colors , Filters , Quick Charts in Microsoft Power BI 42

Now we will try for

Colors , Filters , Quick Charts in Microsoft Power BI 43

Change data colors, select any colour from drop down :

Colors , Filters , Quick Charts in Microsoft Power BI 44

 

Now let we explore Filter

Colors , Filters , Quick Charts in Microsoft Power BI 45

Selct filter for visual level filters:

Colors , Filters , Quick Charts in Microsoft Power BI 46

Select year 2015 check box:

Colors , Filters , Quick Charts in Microsoft Power BI 47

It displays values for 2015 year only

Advance filtering:

Select filter for month and Quarter and year:

Colors , Filters , Quick Charts in Microsoft Power BI 48

Select value as ‘less than ‘ 2016

Colors , Filters , Quick Charts in Microsoft Power BI 49

It displays results for 2015 year only not for 2016 and 2017.

Let explore filtering on more than one filed:

Select a new bar chart with Item, Region and unit fields:

Colors , Filters , Quick Charts in Microsoft Power BI 50

Expand next level:

Colors , Filters , Quick Charts in Microsoft Power BI 51

Select Filters field and use drop down for Item and Region:

Colors , Filters , Quick Charts in Microsoft Power BI 52

Select copy and Pencil from the filter:

Colors , Filters , Quick Charts in Microsoft Power BI 53

On selecting item Region filter is automatically changed and only East region is there.

Now if I select one more item from Item filter:

Colors , Filters , Quick Charts in Microsoft Power BI 54

On selecting bag from Item filter, new region is also present for Region filter.

We can filter data on the basis of units too:

Colors , Filters , Quick Charts in Microsoft Power BI 55

 

Colors , Filters , Quick Charts in Microsoft Power BI 56

here we can give any number and select values from drop down

select value ‘is greater than’ from drop down and give value as 20 in text field:

Colors , Filters , Quick Charts in Microsoft Power BI 57

It is showing results for unit 30 and 40.

It was all about adding colour and filter on different fields.

Tags:

You Might also Like

Leave a Comment

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