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 :

For Page 2 we have scatter chart:

These filters are for that particular visualization

Click outside from visualization

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

Go to Page 1

Drag and drop Order date:

 

Select Filter type drop down:

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

 

Go to Page 2

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

Select Clear filter

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

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,

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

 

Click on blank space on page and Select Slicer

Now select Order date

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

Add one more slicer for Region:

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

Select horizontal for Orientation:

Now we can select horizontally for Region field values:

 

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

Leave a Comment

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