Forum Discussion

dominik_thoe's avatar
dominik_thoe
Frequent Visitor
5 years ago
Solved

Filter table

Hello, I have to table visuals based on the same table (Account).   Structure first visual Account, Classification, Segment, Parent Account   Structure second visual Parent Account, Account, C...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi， dominik_thoe 

    I create a sample pbix file,please check it for  more details.

    In order to avoid cross filtering of fields in a table, you need to copy the table to create another independent  table visual.

    Then create a visual control measure and  drag it to table visual filter pane to filter data.

    Visual control = 
VAR flag =
    IF (
        SELECTEDVALUE ( 'Table copy'[Parent Account] )
            = SELECTEDVALUE ( 'Table1'[Parent Account] ),
        1,
        0
    )
RETURN
    IF ( ISFILTERED ( Table1[Parent Account] ), flag, 1 )

     

    The result will show as below:

     

    Best Regards,
    Community Support Team _ Eason

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi， dominik_thoe 

I create a sample pbix file,please check it for  more details.

In order to avoid cross filtering of fields in a table, you need to copy the table to create another independent  table visual.

Then create a visual control measure and  drag it to table visual filter pane to filter data.

Visual control = 
VAR flag =
    IF (
        SELECTEDVALUE ( 'Table copy'[Parent Account] )
            = SELECTEDVALUE ( 'Table1'[Parent Account] ),
        1,
        0
    )
RETURN
    IF ( ISFILTERED ( Table1[Parent Account] ), flag, 1 )

 

The result will show as below:

 

Best Regards,
Community Support Team _ Eason