Forum Discussion

coelidonum's avatar
coelidonum
Regular Visitor
3 years ago
Solved

filters

Hello,

 

I have 3 graphs on a page and some filters. One of these filters is the filter 'Country' the set of data of the variable 'Country' in in the tab "LinkedIn RAW data". I want to create a new column named "Country all" . It has to keep all the values of the column Country of the tab "LinkedIn RAW data", ignoring the filters.
 
I've tried:
 
Country all = MINX(ALL('LinkedIn RAW data'), 'LinkedIn RAW data'[Country])
 
but it doesn't really work. Any idea?
 
 
 
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi coelidonum 

    You can refer to following ways.

    Choose the slicer, then click "Edit interactions" in Format

     

    Then cancel the filter of other visuals

    Then the visual will not be affected by the slicer

    You can refer to the following link to know more about the function.

    Change how visuals interact in a report - Power BI | Microsoft Learn

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi coelidonum 

    You can refer to following ways.

    Choose the slicer, then click "Edit interactions" in Format

     

    Then cancel the filter of other visuals

    Then the visual will not be affected by the slicer

    You can refer to the following link to know more about the function.

    Change how visuals interact in a report - Power BI | Microsoft Learn

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.