Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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

Anonymous
6 years ago
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.

5 Replies

Anonymous
Not applicable
6 years ago
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
  Not applicable
  6 years ago
  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
    Not applicable
    6 years ago
    Anonymous - You can use "Edit Interactions" for this.
    
    Click Format tab.
    
    Click Edit Interactions button.
    
    Select the visual that should not be affecting the other visual.
    
    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.

Related content