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, 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?