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

Need help - filter report

Hi, 

 

I have a problem when I'm filtering in my report.

When I filter on column A, I didn't want that it affect column B.

Is there any way to do this in Power BI?

 

Many thanks for helping

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Re: Need help - filter report

@mims_tl , I think I misunderstood - I thought the filtering was occurring by selecting a value on one of the other visuals. But apparently it's in the filter pane - right? If that's the case, you will need to modify the value that is used in the card. You can create a measure like this, which you can use in the card:

AVG CustomerReview = 
CALCULATE(
    AVERAGE('YourTable'[CustomerReviewValue]),
    ALL('YourTable'[CustomerReview])
)

Using CALCULATE, you can modify the "Filter Context". In this case you want the filter on "CustomerReview" to be ignored, so you use ALL on that column.

 

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson

 

View solution in original post

5 REPLIES 5
Super User II
Super User II

Re: Need help - filter report

@mims_tl  - There are ways to control interactions, but we'll need more specifics on what exactly you're trying to accomplish - could you provide more details?

Thanks,

Nathan

mims_tl Frequent Visitor
Frequent Visitor

Re: Need help - filter report

@natelpeterson 

 

So what I actually have without filter is this (first picture).

When I filter on CustomerReview, the data for the three visualization changes (see second picture).

The target is that when I filter on CustomerReview, the column AVG CustomerReview shouldn't change.

 

 

viz1.PNG

 

 

viz2.PNG

Super User II
Super User II

Re: Need help - filter report

@mims_tl  - You can use "Edit Interactions" for this.

  1. Click Format tab.
  2. Click Edit Interactions button.
  3. Select the visual that should not be affecting the other visual.
  4. Hover over upper right-hand corner of the visual that should not be affected, and select "None".

Edit Interactions - None.PNG

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson
mims_tl Frequent Visitor
Frequent Visitor

Re: Need help - filter report

@natelpeterson 

 

I tried it, but it is still changing when I filter. 

Am I missing something?

 

NONEé.PNG 

Super User II
Super User II

Re: Need help - filter report

@mims_tl , I think I misunderstood - I thought the filtering was occurring by selecting a value on one of the other visuals. But apparently it's in the filter pane - right? If that's the case, you will need to modify the value that is used in the card. You can create a measure like this, which you can use in the card:

AVG CustomerReview = 
CALCULATE(
    AVERAGE('YourTable'[CustomerReviewValue]),
    ALL('YourTable'[CustomerReview])
)

Using CALCULATE, you can modify the "Filter Context". In this case you want the filter on "CustomerReview" to be ignored, so you use ALL on that column.

 

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson

 

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors