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

Using Multiple Cross-Filter Interactions PowerBI Embedded

Hello, 

 

We have created our product through embedding multiple reports on our web portal for our clients to consume the rich analytics experience provided by PowerBI dashboards. Each report has approx. 4-5 different visual elements i.e. Bar-Charts, Donuts, etc.

We observed that while cross-filtering we can only cross-filter on one visual where all the other visual re-configure based on the selection of the visual. 

How can we make this happen with more than one visual. Say we select a bar-chart visual, and then is it possible to hold 'CTRL' key to select visuals from the other cross-filtered visuals to see the corresponding changes in the remaining visuals. If it is possible, what configurations are required to enable this functionality.

 

Thanks & Best Regards,

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: Using Multiple Cross-Filter Interactions PowerBI Embedded

Hi @Jig_S,

 

As I  mentioned in my above post, if we select multiple items on one visual, and then to select items on another visual, then the items in original visual will be removed. So I don't think your requirement can be achieved in current version of Power BI.

 

For this requirement, I would recommend you submit a feature request in the idea forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Charlie Liao

View solution in original post

8 REPLIES 8
Microsoft
Microsoft

Re: Using Multiple Cross-Filter Interactions PowerBI Embedded

Hi @Jig_S

 

What do you mean by cross-filtered visuals?

 

I have tested it on my local environment, we can select multiple item inside one visual. If we select multiple items on one visual, and then to select item on another visual, then the items will be removed.

 

If this is not what you want, please provide us more information, if possible provide us some screenshots, so that we can make further analysis.

 

Regards,

Charlie Liao

Jig_S
Frequent Visitor

Re: Using Multiple Cross-Filter Interactions PowerBI Embedded

Hi Charlie,

 

Thanks for your reply. We need to select multiple items across visuals. Say we select an item in 1st Visual, and then want further cross-filter related to the other visuals, we should be able to select the items across visuals so that we can analyze what is the effect on one visual on selecting items from multiple visuals. Its like an "AND/OR" implementation, but on a visual level.

 

Thanks & Regards,

Jigar

Microsoft
Microsoft

Re: Using Multiple Cross-Filter Interactions PowerBI Embedded

Hi @Jig_S,

 

As I  mentioned in my above post, if we select multiple items on one visual, and then to select items on another visual, then the items in original visual will be removed. So I don't think your requirement can be achieved in current version of Power BI.

 

For this requirement, I would recommend you submit a feature request in the idea forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Charlie Liao

View solution in original post

sean-byers
New Member

Re: Using Multiple Cross-Filter Interactions PowerBI Embedded

Was this ever submitted as an idea on the Power BI Ideas forum?

 

I am looking for the same functionality as it would be very helpful for some of the reports that I've built where I like to use visuals as my data slicers

Jig_S
Frequent Visitor

Re: Using Multiple Cross-Filter Interactions PowerBI Embedded

I think it was submitted as ideas

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9325809-use-charts-as-slicers

 

Though they might not have implemented the full intended functionality. See the second comment.

 

Thanks,

 

tylersbrown01
Frequent Visitor

Re: Using Multiple Cross-Filter Interactions PowerBI Embedded

I totally want this to happen as well. Hope it does! 

As a side note - this might be possible with PBI embedded if you can capture the filter settings using javascript. Just an idea!

AlexMR
Regular Visitor

Re: Using Multiple Cross-Filter Interactions PowerBI Embedded

I am also looking for this functionality in Power BI.  Multiple-cross filtering among visuals is the default behavior of Qlik Sense. It is also very intuitive.

 

I am very disappointed that Power BI does not implement this important feature.

aucklanduser Helper I
Helper I

Re: Using Multiple Cross-Filter Interactions PowerBI Embedded

This feature is now working, you can control click across multiple visuals successfully

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.