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

Filters are not being displayed well (not Acumulative)

Hey! I am very new at Power BI and I love it but, there is some kind of problem (or maybe I am doing something wrong) when I select the some data in a chart (i.e. number of sales this month) and with that selected I want to select other related data from other chart on the report (i.e sales by electronic department), it will give me the sales of the electronic department of ALL entries not only for this month (filter 1).

 

My question is, how could the program keep the previous filters and no loosing them across the selections?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Filters are not being displayed well (not Acumulative)

Hey, 

 

let's assume your report contains 3 visuals

  • bar chart A
  • bar chart B
  • line chart I

Selecting the bar "A1"  from "bar chart A" will filter all the other visuals, if you want to keep the selection from "bar chart A" if you mark a bar in "bar chart B", just hit the CTRL-key before you mark the bar in "bar chart B", let's assume you selected/marked bar "B1".

 

Now the line chart will be filtered by "A1" and "B1".

 

Hopefully this is what you are looking for.

 

Regards,

Tom 

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Filters are not being displayed well (not Acumulative)

Hey, 

 

let's assume your report contains 3 visuals

  • bar chart A
  • bar chart B
  • line chart I

Selecting the bar "A1"  from "bar chart A" will filter all the other visuals, if you want to keep the selection from "bar chart A" if you mark a bar in "bar chart B", just hit the CTRL-key before you mark the bar in "bar chart B", let's assume you selected/marked bar "B1".

 

Now the line chart will be filtered by "A1" and "B1".

 

Hopefully this is what you are looking for.

 

Regards,

Tom 

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post

dpeper6 Frequent Visitor
Frequent Visitor

Re: Filters are not being displayed well (not Acumulative)

yeah!! you saved my day!! 🙂

 

Is there any option to make this behaviour as predeterm way of use the data?

 

What's the key to do this when your watching the report from a mobile device?

 

Thanks!!! Smiley Very Happy

 

Super User
Super User

Re: Filters are not being displayed well (not Acumulative)

Hey,

unfortunately it's not possible to make this the default behavior.

This does not work if you are using touch, as far as I know. But maybe I'm wrong, you might be lucky that this is possible to use a "virtual" keyboard that is able to "lock" the CTRL-key.

 

Regards,

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 331 members 3,435 guests
Please welcome our newest community members: