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

[Siva]

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

[Rajinikanth_BI]

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.

[iam0kru]

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.

[Anonymous]

@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

[iam0kru]

Thanks you vmakhija.  This works for my purposes.

[sushmasushma]

thank you so much @Anonymous

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

[Anonymous]

@sushmasushma

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

[sushmasushma]

@Anonymous thank you so much.

[sushmasushma]

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,

[sushmasushma]

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]

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

[osinquinvdm]

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]

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

[sushmasushma]

Hello

Plz tell me how drill through to other pages?

[yourbedhead]

How do you accomplish this?

[yourbedhead]

How do you accomplish this?

[Haider121]

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.

[Seth_C_Bauer]

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.

[Anonymous]

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