Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Metric not filtering by date

Hi All! I've loaded 3 tables and joined them. But I have the problem that one metric doesn't get filtered by date. The Cost metric. I don't know what I'm doing wrong. This table is using Order Dat...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks!

 

I'm kind of you new with powerBI and I've never done more than one relationship between tables.

I've looked on the internet about the Bridge Tables and under PowerBI documentation, it says this used to be a workaround but not needed anymore. See your self https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships

 

 

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

I am sorry that i have forgotten attaching the img, please see this:

 

Best Regards,

Giotto

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

     

    I've tried your solution but it didn't work.

    But you gave me one idea and I've change a few things.

    Link to Now Order ID works. Link to Campaign ID works.

     

    The problem I have is that the Order Date from Google Ads table is not linked to Append1. PowerBI doesn't allow me an active relationship.

    I tried both. In Red, a direct connection between tables. In green using a Bridge Table.

     

    • v-gizhi-msft's avatar
      v-gizhi-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi,

       

      Please try to change the relationship marked by green circle to inactive and change the relationship marked by aqua circle to active.

       

      Best Regards,

      Giotto

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks, Giotto

         

        I've applied your suggestion.

        The problem now is that

        1. I can't filter by Google Ads table Campaign Type. Before I was able to select the Campaign Type, and the Campaign ID was linked to Data Studio table, the Orders IDs got filtered.
        2. Cost from Google Ads table doesn't show on my table using Order Date form Append1 table.