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

Transferring a chart cross filter into a slicer

Hi,

 

I am looking for a way of transfering chart cross filtering into a slicer on a page. I cannot think of a way to do this within power BI but was hoping someone could help/clarify. The below screenshots clarify what I mean.

 

We start with the base report:

Russia Filter.jpg

 

We then use the left hand bar chart to cross filter the column chart:

 

Cross Filter.jpg

 

What I would like to do, is then somehow automatically move that cross filtering into the top level slicer as shown:

Russia Filter 2.jpg

 

Any help/ideas much appreciated. Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-alq-msft
Microsoft

Re: Transferring a chart cross filter into a slicer

Hi, @Davidson919 

 

Based on description, you may try to use 'Attribtue Slicer' from marketplace. It may help, but it can't be used as a sync slicer.

 

Here is my sample data for testing.

b1.png

 

Reult:

b2.png

b3.png

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

Re: Transferring a chart cross filter into a slicer

Not sure I got it completely. In Edit Interaction in format. There two option. Filter or Show filled bars.

 

Interactions.png

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin


Davidson919
Frequent Visitor

Re: Transferring a chart cross filter into a slicer

Hi @amitchandak . Not this isn't about filtering/ highlighting, its about if I can actually somehow transfer the cross filtering from the bar chart into the above slicer.

 

This would then allow me to toggle between different charts but allow me to have the whole report page filtered to Russia.

 

Apologies if this is unclear, it is a slightly odd requirment (and I doubt the functionality exists).

Microsoft v-alq-msft
Microsoft

Re: Transferring a chart cross filter into a slicer

Hi, @Davidson919 

 

Based on description, you may try to use 'Attribtue Slicer' from marketplace. It may help, but it can't be used as a sync slicer.

 

Here is my sample data for testing.

b1.png

 

Reult:

b2.png

b3.png

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Microsoft v-alq-msft
Microsoft

Re: Transferring a chart cross filter into a slicer

Hi, @Davidson919 

 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.
 
Best Regards
Allan

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors