LOADING

Type to search

Combine filters and charts for more than one page

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

PowerBI

Combine filters and charts for more than one page

Share

We have already seen using filter and slicer on one page, today we are going to learn combining filters and slicer for more than one page.

On Page 1 we have  map chart with Profit measure result :

Combine filters and charts for more than one page 29

For Page 2 we have scatter chart:

Combine filters and charts for more than one page 30

Combine filters and charts for more than one page 31

These filters are for that particular visualization

Click outside from visualization

Combine filters and charts for more than one page 32we have Filters list here. We need to use these filters for more than one page.

Go to Page 1

Combine filters and charts for more than one page 33

Drag and drop Order date:

Combine filters and charts for more than one page 34

 

Combine filters and charts for more than one page 35

Select Filter type drop down:

Combine filters and charts for more than one page 36

Select Advanced filter and enter values in filter field, Click on Apply filter button:

 

Combine filters and charts for more than one page 37

Go to Page 2

Combine filters and charts for more than one page 38

We can see results are changed, now let we remove filter:

Combine filters and charts for more than one page 39

Select Clear filter

Combine filters and charts for more than one page 40

Go to Page 1, we can see filter are remove from this page as well

Combine filters and charts for more than one page 41

This was about using filter more than one page. Now we will combine two pages on one page and use slicer for both charts

 

Go to Page 1 and select map chart and ctrl C, open new page 3 ctrl V here and map will be pasted on this page,Combine filters and charts for more than one page 42

Now do same for Page 2. Adjust both charts side by side

 

Combine filters and charts for more than one page 43

Click on blank space on page and Select Slicer

Combine filters and charts for more than one page 44

Now select Order date

Combine filters and charts for more than one page 45

Drag scroll for Order date and results are modified for both charts:

Combine filters and charts for more than one page 46

Add one more slicer for Region:

Combine filters and charts for more than one page 47

Go to Format and expand General option now here under orientation we can select Vertical or horizontal option for this slicer:

Combine filters and charts for more than one page 48

Select horizontal for Orientation:

Combine filters and charts for more than one page 49

Now we can select horizontally for Region field values:

Combine filters and charts for more than one page 50

 

It will show result for both filters.

In this blog we learn about using Filer on multiple page and combine multiple reports on one page.

Tags:

You Might also Like