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,

 

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?