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, Classification, Segment

 

I want to filter the second visual by the Parent Account that I select in the first visual to see all accounts that are linked to the Parent Account including their assigned Classification/Segment. The standard function filters the second visual with all objects, not only the Parent Account. 

Any idea how I can solve this?

 

thanks

Dominik

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

     

4 Replies

    • dominik_thoe's avatar
      dominik_thoe
      Frequent Visitor
      5 years ago

      Hi Paul.

      I use only one table: Account. Data from connected tables is not used in the visual.

      I want to filter the second table by the parent account only and not by classification, segment and frequency to display all accounts with parent account 1004969 (see grren box).

      Hope this helps.

       

      thanks

       

  • 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