Forum Discussion

Jeremie's avatar
Jeremie
Frequent Visitor
9 years ago
Solved

Show Items with no data filtering behaviour

I've noticed that the "Show items with no data" has changed the way filtering works.  Suppose I have two tables, fact and dim.  Fact contains the values 3,4,5,5 and dim contains 1,2,3.  They are rela...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Jeremie,

     

    Hi Jeremie,

     

    That's the function of "Cross filter direction". If you change it into "both", the result would be right. (part 2 of the snapshot)  powerbi-desktop-create-and-manage-relationships

    >>>Both - This is the most common, default direction. This means for filtering purposes, both tables are treated as if they're a single table.  

     

    To be simple, Power BI can't filter dim table from fact table to dim table. 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Jeremie,

 

Hi Jeremie,

 

That's the function of "Cross filter direction". If you change it into "both", the result would be right. (part 2 of the snapshot)  powerbi-desktop-create-and-manage-relationships

>>>Both - This is the most common, default direction. This means for filtering purposes, both tables are treated as if they're a single table.  

 

To be simple, Power BI can't filter dim table from fact table to dim table. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

  • Jeremie's avatar
    Jeremie
    Frequent Visitor
    9 years ago

    Thanks Dale,

     

    The cross filter direction doesn't really answer my question, however your comment that "Power BI can't filter dim table from fact table to dim table." does. 

     

    thanks