cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vickyd Member
Member

Filter data in chart instead of just highlighting the relevant portion

Say you have 2 bar charts in a report. One showing revenue by Org and another showing revenue by Account.  If I click on one of the Orgs in the 1st bar chart, the 2nd chart shows all Accounts relevant to the Org highlighted with the rest lightened/grayed out.

 

Is there a way to change that beviour so that it only shows the relevant Accounts and does not show the rest at all? 

7 REPLIES 7
Super User
Super User

Re: Filter data in chart instead of just highlighting the relevant portion

Not that I am aware of, you want a Slicer instead. So, create an Org slicer.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

vickyd Member
Member

Re: Filter data in chart instead of just highlighting the relevant portion

Yes slicer is an alternative but it takes up space which I thought could be avoided with the clickable chart option. Anyway, hopefully soemthing that will get added in the future. 

andre
Advisor

Re: Filter data in chart instead of just highlighting the relevant portion

I agree, every chart should have an option to either show the highlighted (before click) value or not...   Particularly for Bar Charts where not only does it become difficult to see the relative value after a click on a different chart to filter but also, if there are a lot of bars on that bar chart, a lot of them just become gray and they become nothing but noise on the visual.

 

 

dvadithala New Member
New Member

Re: Filter data in chart instead of just highlighting the relevant portion

Hi there,

 

I was looking for the samething. It's a shame that this feature is only available few visualizations. What's more confusing is that I can't see the selections if I've selected or filtered using the objects instead of Slicer object. Am I missing something here?

 

Cheers,

DV

andre
Advisor

Re: Filter data in chart instead of just highlighting the relevant portion

No, different charts act differently in response to click or filter action, there is definitely room to improve there.

Power BI Team AlexGorev
Power BI Team

Re: Filter data in chart instead of just highlighting the relevant portion

We've been discussing the capability of setting the filter behavior for visuals like Filter, Highlight, None. It is in our backlog but has a lower relative priority comparing to other customer feature requests.

 

I suggest searching on the forums and making sure this feature request is added to the list:

http://community.powerbi.com/t5/Desktop/Too-many-values/m-p/3050#U3050

 

For now you can use slicer as suggested in the previos replies.

 

Alex.

Moderator WillT
Moderator

Re: Filter data in chart instead of just highlighting the relevant portion

We have recently added a feature called "Visual Interactions" that lets you control how charts cross-highlight or cross-filter each other! You can see details on it in the November update video that was posted here: https://www.youtube.com/watch?v=ErHvpkyQjSg&feature=youtu.be Hope that helps!

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,244)