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

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

Siva — Wed, 05 Aug 2015 19:24:03 GMT

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

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

Anonymous — Wed, 05 Aug 2015 19:48:08 GMT

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.

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

Anonymous — Fri, 22 Jul 2016 12:17:12 GMT

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

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

Haider121 — Mon, 16 Jan 2017 11:24:15 GMT

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.

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

osinquinvdm — Fri, 10 Mar 2017 20:51:22 GMT

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)

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

TePe — Sun, 10 Sep 2017 14:48:58 GMT

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

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

yourbedhead — Tue, 03 Oct 2017 18:38:37 GMT

How do you accomplish this?

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

yourbedhead — Tue, 03 Oct 2017 18:40:45 GMT

How do you accomplish this?

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

sushmasushma — Fri, 24 Nov 2017 03:48:22 GMT

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

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

sushmasushma — Fri, 24 Nov 2017 03:58:58 GMT

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

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

sushmasushma — Fri, 24 Nov 2017 04:00:27 GMT

Hello

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,

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

sushmasushma — Fri, 15 Dec 2017 07:47:16 GMT

Hello

Plz tell me how drill through to other pages?

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

iam0kru — Tue, 27 Mar 2018 17:38:19 GMT

Hello, can the data from page 1 and page 2 on a report be linked? Trying to figure out what the point of a multi page report is if the data does't connect somehow. If I have to make people select their filters again then I don;t see the use of the subsequent pages.

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

Anonymous — Wed, 28 Mar 2018 07:04:41 GMT

iam0kru

There is now a feature for "Sync Slicers". See below screenshot for where to find it -

Its under View tab. It will allow you to sync the slicers on multiple pages. So a value selected on one page will be carried forward to another page.

You can define what all slicers should be synced across pages.

Regards

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

sushmasushma — Wed, 28 Mar 2018 08:47:36 GMT

thank you so much Anonymous

but it is working only for slicers there is any possibility for filters?

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

Anonymous — Wed, 28 Mar 2018 09:26:17 GMT

sushmasushma

If I can understand your requirement properly, you can make use of "Report Level Filters"

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

iam0kru — Wed, 28 Mar 2018 16:12:32 GMT

Thanks you vmakhija. This works for my purposes.

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

sushmasushma — Mon, 02 Apr 2018 03:53:18 GMT

Anonymous thank you so much.

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

Rajinikanth_BI — Thu, 27 Aug 2020 07:41:18 GMT

Is there a way to apply global actions the functionality similar to global actions of tableau.

If i click on chart 1 , chart2 of page1 then page 2 should filtered for the same selection.

Thanks in advance.