cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlB
Super User
Super User

Propagating visual x-filtering across pages

Hi all,

Imagine we have a bar chart that shows the sales per location in page 1 of a pbi report. If the user clicks on the bar for a location on the chart, the other elements on page 1 will be filtered (or highlighted) and show the result for that location.

That is limited to the same page. What we would want is one of two things:

1. When the user clicks on the bar for a location on the chart and they go to a different page (page 2) in the report, the visuals in page 2 will also be filtered down to the location.

2. On top of point 1, when the user clicks on the location the system takes them to page 2. Sort of the behavior provided by a bookmark but that is triggered when you click on a bar of the chart.

 

Are any of the points above possible in pbi?

If not, any ideas on how to get a similar behavior?

 

@MFelix  @TomMartens @Greg_Deckler @mahoneypat @parry2k 

Many thanks

 

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @AlB ,

 

For this you need to use the drill-torugh option and you can set a button that does the change to page two:

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

 

You cannot make it with a direct click on the bar chart but a button can pop up for the drill trough.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

6 REPLIES 6
TomMartens
Super User
Super User

Hey @AlB ,

 

sorry for the delay.

 

Basically, it's not possible what you are asking for.

This is because, you can not change the "on-click" event from "Select item" to "Navigate to page".

My suggestion is: stick to the drill-through button as recommended by @MFelix.


If the number of locations is static you can combine the idea of @mahoneypat using transparent buttons used as bookmark. that does two things at the same time, navigates to page 2, and uses the preselection of a slicer on page 2. This pre-selection is part of the bookmark selection. 


Here you will find a little pbix file that provides what you are looking for, at least to my understanding.
https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/ETUZtT7VpA5Apb8jIcE7qNUBw7zXg...
On page 1 there are two colored rectangles (used as bookmark navigation) that are overlaying the columns in the chart.
There are 2 bookmarks defined each for a slicer selection on page 2

Even if this meets your requirements, my recommendation is: do not use this because it can become pretty ugly quite soon.


Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
MFelix
Super User
Super User

Hi @AlB ,

 

For this you need to use the drill-torugh option and you can set a button that does the change to page two:

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

 

You cannot make it with a direct click on the bar chart but a button can pop up for the drill trough.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

mahoneypat
Super User
Super User

I think the closest you could get (and this would only work in the Service) would be to make a button and a measure that dynamically generates a web url to the desired report page, along with a dynamic filter generated with the FILTERS function.  The user would need to click on the bar and then the button.  I guess you could also create blank buttons over each bar, each with the web url for that bar.

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


AlB
Super User
Super User

Thanks @Ashish_Mathur  @VahidDM 

The synced location slicer is what we have now already but the users are looking for what I describe in point 1.

What about point 2?

 

 

VahidDM
Community Champion
Community Champion

Hi @AlB 

 

Pretty sure No.1 is not possible (as far as I know), you can sync Slicer but not pages.

 


Appreciate your Kudos!!
LinkedIn: 
www.linkedin.com/in/vahid-dm/

 

 

Ashish_Mathur
Super User
Super User

Hi,

Location can be a slicer and you can sync slicers between pages.  Will that work?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors