cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Siva Frequent Visitor
Frequent Visitor

How to Link Charts/Tables in Page 1 and Page 2 ?

Sir/Madam,

 

I am trying to link charts and tables in Page 1 and Page 2.

 

If I click on any series in any of the chart in Page 1, I want the table/chart in Page 2 to show up only for the selected series in Page 1. Could you please help me how to get this done.

 

Thanks,

Siva

17 REPLIES 17
Super User
Super User

Re: How to Link Charts/Tables in Page 1 and Page 2 ?

Hi Siva,

Each page is self contained, so all filters/slicers etc. that you apply will only work with that page.

So the dynamic sort of experience you are looking for isn't there currently.

Take a look here to see if it is a feature request, or add it as a feature request (I'd vote for it).

 

To "manually" get this sort of behavour to work (kind of). You could create a visual on page 1, pin that to your dashboard, create a visual on page 2 with the same filters/slicer and do a custom link from the dashboard visual to the URL of the 2nd page. This would sort of get you a drill down to a different visual with the same filters.

 

Untitled.png

Near SE WI? Join our PUG Milwaukee Brew City PUG
Thimma Member
Member

Re: How to Link Charts/Tables in Page 1 and Page 2 ?

Hi Eno,

 

I tried this option and it works as a hyperlink but not passing the filter which I click any one of the product from the chart. As far as I know Microsoft is not yet looked in to this.

 

Correct me if I am wrong.

 

Thanks,

Thimma

Haider121 Frequent Visitor
Frequent Visitor

Re: How to Link Charts/Tables in Page 1 and Page 2 ?

You could create a report level filter and when you filter on page 1 page 2 will also get that filter considering the dataset is linked or has the same filter column.

osinquinvdm Regular Visitor
Regular Visitor

Re: How to Link Charts/Tables in Page 1 and Page 2 ?

I wish PBI would offer the possibility to pass selection across pages. But for now, if the selection applies to all page what about using parameters.

Query parameters are currently only supported in power bi desktop and not in power bi service .

If at least it was available in the cloud version, the user could change the value of the parameter (and you could set up the parameter so that it displays a drop down list with all the possible values)

 

TePe
Advisor

Re: How to Link Charts/Tables in Page 1 and Page 2 ?

With the September version you now can "drill through" to other pages...

yourbedhead Frequent Visitor
Frequent Visitor

Re: How to Link Charts/Tables in Page 1 and Page 2 ?

How do you accomplish this?

yourbedhead Frequent Visitor
Frequent Visitor

Re: How to Link Charts/Tables in Page 1 and Page 2 ?

How do you accomplish this?

sushmasushma Regular Visitor
Regular Visitor

Re: How to Link Charts/Tables in Page 1 and Page 2 ?

Hello

 

I am trying to link charts in Page 1 and Page 2.

 

If I click on any series in any of the chart in Page 1, I want the chart in Page 2 to show up only for the selected series in Page 1. Could you please help me how to get this done.

 

Thanks

sushmasushma Regular Visitor
Regular Visitor

Re: How to Link Charts/Tables in Page 1 and Page 2 ?

Hello

 

I am trying to link charts in Page 1 and Page 2.

 

If I click on any series in any of the chart in Page 1, I want the chart in Page 2 to show up only for the selected series in Page 1. Could you please help me how to get this done.

 

Thanks