Need help - filter report

[Anonymous]

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

[Anonymous]

@Anonymous  - 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

[Anonymous]

@Anonymous 

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.

[Anonymous]

@Anonymous  - 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".

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

[Anonymous]

@Anonymous 

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

Am I missing something?

 

[Anonymous · Accepted solution]

@Anonymous , 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.