Hierarchy filter

[pstanek]

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?

[Anonymous]

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

[pstanek]

Problem is that, i can´t find related anymore within calculated column.

http://community.powerbi.com/t5/Desktop/Related/m-p/91765

I am not also sure how to create hierarchy column.

[Anonymous]

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