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
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.

 

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

    Hi,

     

    For your issue 1, you can create a new slicer table to filter 'Google Ads'[Campaign type], try like this:

    SlicerTable =
DISTINCT (
    SELECTCOLUMNS ( 'Data Studio', "Campaign ID", 'Data Studio'[Campaign ID] )
)

    Then create this table and 'Google Ads' table as one-to-many relationship.

    Choose this table's field as a slicer, and you can filter Campaign Type by Campaign ID.

    For you issue 2, please try to add [Order Date] field from 'Order Date Key' table to your original table visual.

    Hope this helps.

    if these still do not solve your issue, please share some sample data and relationships(linked columns) between each two tables for me to help you further.

     

    Best Regards,

    Giotto

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Giotto

       

      Here you can find a file with sample data.

      Download file 

       

      Thanks for your help

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi v-gizhi-msft 

        Have you seen the file?