Forum Discussion

pstanek's avatar
pstanek
Post Patron
9 years ago

Hierarchy filter

Hi I tried to use hierchy filter visual, but it failed  when columns were from tables with relation, not from the same table.

 

Table  B->A

Column hierarchy First  b from B,  second a from A --because of cross filtering  . How is that possible?

                                   

Need Help
Show and Tell

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi pstanek,

     

    Based on test, it is impossible to directly create a hierarchy column with columns from multiple tables.


    You can add a calculate column one table to store the related column which from other table, then use this column to create the hierarchy column, and drag it to hierarchy slicer.(low performance)

     

    Below is the sample.

     

    calculate column:

    Desc = RELATED(Sheet1[Desc])

     

     

    Regards,

    Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi pstanek,

         

        Did you use the direct query mode to connect the datasource?If you want to use related function, you should ensure these tables contain the relationship and it not works when you connect the datasoure with direct query mode.

         

        >>I am not also sure how to create hierarchy column.

        Click on one column -> Right Click.

        Then you can drag other columns which in the same table to this hierarchy column.

         

        Regards,

        Xiaoxin Sheng